logo资料库

PLSQL13帮助.pdf

第1页 / 共283页
第2页 / 共283页
第3页 / 共283页
第4页 / 共283页
第5页 / 共283页
第6页 / 共283页
第7页 / 共283页
第8页 / 共283页
资料共283页,剩余部分请下载后查看
1. Introduction
2. Installation
2.1 System requirements
2.2 Interactive installation
2.3 Silent installation
2.4 Uninstalling PL/SQL Developer
3. Logging on to an Oracle database
4. Writing programs
4.1 Creating a program
4.2 Saving a program
4.3 Modifying a program
4.4 Compiling a program
4.5 Comparing a program
4.6 Compiler preferences
5. Testing programs
5.1 Creating a Test Script
5.2 Executing a Test Script
5.3 Variable types
5.4 Saving Test Scripts
5.5 Tracking run-time errors
5.6 Package states & Java session states
5.7 Viewing result sets
5.8 Viewing dbms_output
5.9 Viewing HTP output
5.10 Debugging
5.11 Tracing execution
5.12 Regression testing
5.13 Creating Standard Tests
6. Optimizing
6.1 Using the Explain Plan Window
6.2 Automatic statistics
6.3 The PL/SQL Profiler
6.4 SQL Trace
7. Ad hoc SQL
7.1 Using the SQL Window
7.2 Result grid manipulation
7.3 Query By Example mode
7.4 Linked Queries
7.5 Substitution variables
7.6 Updating the database
7.7 Viewing and editing XMLTYPE columns
7.8 Comparing records
7.9 Direct Query Export
7.10 Comment directives
7.11 Saving SQL Scripts
7.12 Creating Standard Queries
8. The Command Window
8.1 Entering SQL statements and commands
8.2 Developing command files
8.3 Supported commands
9. Creating and modifying non-PL/SQL objects
9.1 The table definition editor
9.2 The sequence definition editor
9.3 The synonym definition editor
9.4 The library definition editor
9.5 The directory definition editor
9.6 The job definition editor
9.7 The queue definition editor
9.8 The queue table definition editor
9.9 The user definition editor
9.10 The role definition editor
9.11 The profile definition editor
9.12 The database link definition editor
10. DBMS Scheduler
10.1 Creating objects
10.2 Editing objects
10.3 Deleting objects
10.4 Viewing job runs
10.5 Viewing running jobs
11. Diagrams
11.1 Creating a diagram
11.2 Zooming
11.3 Saving and opening a diagram file
11.4 Updating a diagram
11.5 Printing a diagram
11.6 Exporting a diagram
12. Reports
12.1 Standard reports
12.2 Custom reports
12.3 Variables
12.4 Refining the layout
12.5 The Style Library
12.6 Options
12.7 The Reports menu
13. Graphics
14. Projects
14.1 Creating a new project
14.2 Saving a project
14.3 Adding files to a project
14.4 Adding database objects to a project
14.5 Working with project items
14.6 Compiling a project
15. To-Do Items
15.1 Creating a To-Do Item
15.2 Editing a To-Do Item
15.3 Closing a To-Do Item
15.4 Deleting a To-Do Item
16. The Connection List
16.1 Using the Connection List
16.2 Defining folders and connections
17. Connections, windows, sessions and transactions
17.1 The main connection
17.2 Window connections
17.3 Session mode
17.4 Execution in Multi session or Dual session mode
18. Browsing objects
18.1 Using the Object Browser
18.2 Object Browser Filters
18.3 Object Browser Folders
19. Browsing files
19.1 Setting up the File Browser
19.2 Using the File Browser
20. Preferences
20.1 Oracle – Connection
20.2 Oracle – Options
20.3 Oracle – Compiler
20.4 Oracle – Debugger
20.5 Oracle – Output
20.6 Oracle – Trace
20.7 Oracle – Profiler
20.8 Oracle – Logon History
20.9 Oracle – Hints
20.10 User Interface – Options
20.11 User Interface – Object Browser
20.12 User Interface – Editor
20.13 User Interface – Fonts
20.14 User Interface – Code Assistant
20.15 User Interface – Key Configuration
20.16 User Interface – Appearance
20.17 User Interface – NLS Options
20.18 Window Types – General
20.19 Window Types – Program Window
20.20 Window Types – SQL Window
20.21 Window Types – Test Window
20.22 Window Types – Plan Window
20.23 Tools – Differences
20.24 Tools – Data Generator
20.25 Tools – To-Do List
20.26 Tools – Recall Statement
20.27 Files – Directories
20.28 Files – Extensions
20.29 Files – Format
20.30 Files – Backup
20.31 Files – HTML/XML
20.32 Other – Printing
20.33 Other – Updates & News
20.34 Preference sets
21. Tools
21.1 Object Browser
21.2 Find Database Objects
21.3 Compile Invalid Objects
21.4 Export Tables
21.5 Import Tables
21.6 Export User Objects
21.7 Text Importer
21.8 ODBC Importer
21.9 Data Generator
21.10 Compare User Objects
21.11 Compare Table Data
21.12 Event Monitor
21.13 Sessions
21.14 User Defined Tools
21.15 Test Manager
21.16 Load Tester
22. The Editor
22.1 Selection functions
22.2 Column selection
22.3 Find & Replace
22.4 Code Assistant
22.5 Recalling statements
22.6 Special Copy
22.7 Paste from host language
22.8 Context sensitive help
22.9 Database object popup menu
22.10 Explain Plan
22.11 Macros
22.12 Go to line
22.13 Bookmarks
22.14 Color marks
22.15 Code Contents
22.16 Code Hierarchy
22.17 Code Folding
22.18 Split Editing
22.19 Hyperlink navigation
22.20 Navigation buttons
22.21 Refactoring
22.22 Search Bar
22.23 Web Search
23. The Large Data Editor
23.1 Editing plain text
23.2 Editing RTF
23.3 Editing XML
23.4 Editing HTML
23.5 Editing images
23.6 Editing Hex data
23.7 Invoking an external viewer or editor
24. The Query Builder
24.1 Creating a new select statement
24.2 Modifying an existing select statement
24.3 Manipulating the query definition
24.4 Query Builder Preferences
24.5 Query Builder Plug-Ins
25. The PL/SQL Beautifier
25.1 Defining the options
25.2 Defining the rules
25.3 Using the beautifier
25.4 Suppressing formatting
26. The PL/SQL Clipboard
27. Templates
27.1 The Template Window
27.2 Using a template
27.3 Creating and modifying templates
28. Window List
29. Dockable and Floating Tools
30. Ribbons and Toolbars
31. Document Interface
31.1 Multiple Document Interface (MDI)
31.2 Single Document Interface (SDI)
32. Oracle File System (OFS)
32.1 OFS Manager
32.2 OFS Usage
33. Help systems
33.1 MS Help files
33.2 HTML Manuals
34. Customization
34.1 Preferences
34.2 Window layout
34.3 On-line documentation
34.4 Command-line parameters
34.5 SQL, PL/SQL and Command keywords
34.6 Plug-Ins
PL/SQL Developer 13.0 User’s Guide December 2018
PL/SQL Developer 13.0 User’s Guide 3 5. 2.1 2.2 2.3 2.4 4.1 4.2 4.3 4.4 4.5 4.6 Contents CONTENTS ........................................................................................................................................... 3 INTRODUCTION ...................................................................................................................... 9 1. 2. INSTALLATION ..................................................................................................................... 12 SYSTEM REQUIREMENTS.................................................................................................... 12 INTERACTIVE INSTALLATION ............................................................................................. 12 SILENT INSTALLATION....................................................................................................... 12 UNINSTALLING PL/SQL DEVELOPER ................................................................................ 12 3. LOGGING ON TO AN ORACLE DATABASE .................................................................... 13 4. WRITING PROGRAMS ......................................................................................................... 14 CREATING A PROGRAM ...................................................................................................... 14 SAVING A PROGRAM .......................................................................................................... 15 MODIFYING A PROGRAM ................................................................................................... 16 COMPILING A PROGRAM .................................................................................................... 16 COMPARING A PROGRAM ................................................................................................... 17 COMPILER PREFERENCES ................................................................................................... 18 TESTING PROGRAMS .......................................................................................................... 19 CREATING A TEST SCRIPT ................................................................................................. 19 EXECUTING A TEST SCRIPT ............................................................................................... 20 VARIABLE TYPES ............................................................................................................... 21 SAVING TEST SCRIPTS ....................................................................................................... 22 TRACKING RUN-TIME ERRORS ........................................................................................... 23 PACKAGE STATES & JAVA SESSION STATES ....................................................................... 23 VIEWING RESULT SETS ...................................................................................................... 23 VIEWING DBMS_OUTPUT ................................................................................................... 23 VIEWING HTP OUTPUT ...................................................................................................... 24 DEBUGGING ...................................................................................................................... 24 TRACING EXECUTION ........................................................................................................ 29 REGRESSION TESTING ........................................................................................................ 30 CREATING STANDARD TESTS ............................................................................................ 30 OPTIMIZING .......................................................................................................................... 31 USING THE EXPLAIN PLAN WINDOW ................................................................................. 31 AUTOMATIC STATISTICS .................................................................................................... 33 THE PL/SQL PROFILER ..................................................................................................... 34 SQL TRACE ....................................................................................................................... 34 AD HOC SQL ........................................................................................................................... 36 USING THE SQL WINDOW ................................................................................................. 36 RESULT GRID MANIPULATION............................................................................................ 38 QUERY BY EXAMPLE MODE .............................................................................................. 44 LINKED QUERIES ............................................................................................................... 45 SUBSTITUTION VARIABLES ................................................................................................ 46 UPDATING THE DATABASE ................................................................................................ 47 VIEWING AND EDITING XMLTYPE COLUMNS .................................................................. 48 COMPARING RECORDS ....................................................................................................... 48 DIRECT QUERY EXPORT .................................................................................................... 49 COMMENT DIRECTIVES ...................................................................................................... 49 SAVING SQL SCRIPTS ....................................................................................................... 50 CREATING STANDARD QUERIES ........................................................................................ 50 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 5.10 5.11 5.12 5.13 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9 7.10 7.11 7.12 6. 7. 6.1 6.2 6.3 6.4
4 PL/SQL Developer 13.0 User’s Guide 8. 9. 8.1 8.2 8.3 10.1 10.2 10.3 10.4 10.5 11.1 11.2 11.3 11.4 11.5 11.6 9.1 9.2 9.3 9.4 9.5 9.6 9.7 9.8 9.9 9.10 9.11 9.12 THE COMMAND WINDOW ................................................................................................. 52 ENTERING SQL STATEMENTS AND COMMANDS ................................................................ 52 DEVELOPING COMMAND FILES .......................................................................................... 53 SUPPORTED COMMANDS.................................................................................................... 53 CREATING AND MODIFYING NON-PL/SQL OBJECTS ................................................ 57 THE TABLE DEFINITION EDITOR ......................................................................................... 57 THE SEQUENCE DEFINITION EDITOR .................................................................................. 70 THE SYNONYM DEFINITION EDITOR ................................................................................... 70 THE LIBRARY DEFINITION EDITOR ..................................................................................... 71 THE DIRECTORY DEFINITION EDITOR ................................................................................. 71 THE JOB DEFINITION EDITOR ............................................................................................. 72 THE QUEUE DEFINITION EDITOR ........................................................................................ 72 THE QUEUE TABLE DEFINITION EDITOR ............................................................................. 73 THE USER DEFINITION EDITOR ........................................................................................... 74 THE ROLE DEFINITION EDITOR ........................................................................................... 77 THE PROFILE DEFINITION EDITOR ...................................................................................... 77 THE DATABASE LINK DEFINITION EDITOR .......................................................................... 78 10. DBMS SCHEDULER .............................................................................................................. 79 CREATING OBJECTS ........................................................................................................... 86 EDITING OBJECTS .............................................................................................................. 86 DELETING OBJECTS ........................................................................................................... 86 VIEWING JOB RUNS ........................................................................................................... 86 VIEWING RUNNING JOBS.................................................................................................... 87 11. DIAGRAMS ............................................................................................................................. 88 CREATING A DIAGRAM ...................................................................................................... 88 ZOOMING .......................................................................................................................... 91 SAVING AND OPENING A DIAGRAM FILE ............................................................................ 91 UPDATING A DIAGRAM ...................................................................................................... 91 PRINTING A DIAGRAM ....................................................................................................... 92 EXPORTING A DIAGRAM .................................................................................................... 92 12. REPORTS ................................................................................................................................ 93 STANDARD REPORTS ......................................................................................................... 93 CUSTOM REPORTS ............................................................................................................. 94 VARIABLES ....................................................................................................................... 94 REFINING THE LAYOUT...................................................................................................... 99 THE STYLE LIBRARY ....................................................................................................... 105 OPTIONS .......................................................................................................................... 106 THE REPORTS MENU ........................................................................................................ 107 13. GRAPHICS ............................................................................................................................ 109 PROJECTS ............................................................................................................................ 111 14. CREATING A NEW PROJECT .............................................................................................. 111 SAVING A PROJECT .......................................................................................................... 112 ADDING FILES TO A PROJECT ........................................................................................... 112 ADDING DATABASE OBJECTS TO A PROJECT .................................................................... 112 WORKING WITH PROJECT ITEMS ...................................................................................... 113 COMPILING A PROJECT .................................................................................................... 114 TO-DO ITEMS ...................................................................................................................... 115 CREATING A TO-DO ITEM ............................................................................................... 116 EDITING A TO-DO ITEM................................................................................................... 116 CLOSING A TO-DO ITEM .................................................................................................. 116 12.1 12.2 12.3 12.4 12.5 12.6 12.7 14.1 14.2 14.3 14.4 14.5 14.6 15.1 15.2 15.3 15.
PL/SQL Developer 13.0 User’s Guide 5 18. 19. 20. 16. 15.4 16.1 16.2 19.1 19.2 18.1 18.2 18.3 17.1 17.2 17.3 17.4 DELETING A TO-DO ITEM ................................................................................................ 116 THE CONNECTION LIST ................................................................................................... 117 USING THE CONNECTION LIST ......................................................................................... 117 DEFINING FOLDERS AND CONNECTIONS .......................................................................... 120 17. CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS ............................... 123 THE MAIN CONNECTION .................................................................................................. 123 WINDOW CONNECTIONS .................................................................................................. 123 SESSION MODE ................................................................................................................ 124 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE................................................. 124 BROWSING OBJECTS ........................................................................................................ 125 USING THE OBJECT BROWSER ......................................................................................... 125 OBJECT BROWSER FILTERS ............................................................................................. 132 OBJECT BROWSER FOLDERS ............................................................................................ 133 BROWSING FILES ............................................................................................................... 135 SETTING UP THE FILE BROWSER ...................................................................................... 136 USING THE FILE BROWSER .............................................................................................. 137 PREFERENCES .................................................................................................................... 138 ORACLE – CONNECTION .................................................................................................. 139 20.1 ORACLE – OPTIONS ......................................................................................................... 140 20.2 ORACLE – COMPILER ...................................................................................................... 142 20.3 ORACLE – DEBUGGER ..................................................................................................... 144 20.4 ORACLE – OUTPUT .......................................................................................................... 145 20.5 ORACLE – TRACE ............................................................................................................ 146 20.6 ORACLE – PROFILER ........................................................................................................ 147 20.7 ORACLE – LOGON HISTORY ............................................................................................ 148 20.8 ORACLE – HINTS ............................................................................................................. 149 20.9 USER INTERFACE – OPTIONS ........................................................................................... 151 20.10 USER INTERFACE – OBJECT BROWSER ............................................................................ 153 20.11 USER INTERFACE – EDITOR ............................................................................................. 154 20.12 USER INTERFACE – FONTS ............................................................................................... 158 20.13 USER INTERFACE – CODE ASSISTANT ............................................................................. 159 20.14 USER INTERFACE – KEY CONFIGURATION....................................................................... 161 20.15 20.16 USER INTERFACE – APPEARANCE .................................................................................... 161 20.17 USER INTERFACE – NLS OPTIONS ................................................................................... 163 20.18 WINDOW TYPES – GENERAL ........................................................................................... 164 20.19 WINDOW TYPES – PROGRAM WINDOW ........................................................................... 165 20.20 WINDOW TYPES – SQL WINDOW .................................................................................... 167 20.21 WINDOW TYPES – TEST WINDOW ................................................................................... 170 20.22 WINDOW TYPES – PLAN WINDOW .................................................................................. 170 TOOLS – DIFFERENCES .................................................................................................... 171 20.23 TOOLS – DATA GENERATOR ............................................................................................ 171 20.24 20.25 TOOLS – TO-DO LIST....................................................................................................... 172 20.26 TOOLS – RECALL STATEMENT ......................................................................................... 172 FILES – DIRECTORIES ...................................................................................................... 173 20.27 FILES – EXTENSIONS ....................................................................................................... 175 20.28 FILES – FORMAT .............................................................................................................. 176 20.29 20.30 FILES – BACKUP .............................................................................................................. 177 20.31 FILES – HTML/XML....................................................................................................... 178 20.32 OTHER – PRINTING .......................................................................................................... 179 OTHER – UPDATES & NEWS ............................................................................................ 180 20.33 20.34 PREFERENCE SETS ........................................................................................................... 181
6 PL/SQL Developer 13.0 User’s Guide 21. 22. 21.1 21.2 21.3 21.4 21.5 21.6 21.7 21.8 21.9 21.10 21.11 21.12 21.13 21.14 21.15 21.16 TOOLS ................................................................................................................................... 183 OBJECT BROWSER ........................................................................................................... 183 FIND DATABASE OBJECTS ............................................................................................... 183 COMPILE INVALID OBJECTS ............................................................................................ 184 EXPORT TABLES .............................................................................................................. 185 IMPORT TABLES .............................................................................................................. 188 EXPORT USER OBJECTS ................................................................................................... 190 TEXT IMPORTER .............................................................................................................. 191 ODBC IMPORTER ............................................................................................................ 194 DATA GENERATOR .......................................................................................................... 196 COMPARE USER OBJECTS ................................................................................................ 200 COMPARE TABLE DATA .................................................................................................. 202 EVENT MONITOR............................................................................................................. 204 SESSIONS ......................................................................................................................... 205 USER DEFINED TOOLS ..................................................................................................... 207 TEST MANAGER .............................................................................................................. 211 LOAD TESTER.................................................................................................................. 215 THE EDITOR ........................................................................................................................ 223 SELECTION FUNCTIONS ................................................................................................... 223 22.1 COLUMN SELECTION ....................................................................................................... 223 22.2 FIND & REPLACE ............................................................................................................. 224 22.3 CODE ASSISTANT ............................................................................................................ 225 22.4 RECALLING STATEMENTS ................................................................................................ 227 22.5 SPECIAL COPY ................................................................................................................. 228 22.6 PASTE FROM HOST LANGUAGE ........................................................................................ 229 22.7 CONTEXT SENSITIVE HELP ............................................................................................... 229 22.8 DATABASE OBJECT POPUP MENU ..................................................................................... 229 22.9 EXPLAIN PLAN ................................................................................................................ 229 22.10 22.11 MACROS .......................................................................................................................... 230 GO TO LINE...................................................................................................................... 231 22.12 BOOKMARKS ................................................................................................................... 231 22.13 22.14 COLOR MARKS ................................................................................................................ 232 22.15 CODE CONTENTS ............................................................................................................. 232 22.16 CODE HIERARCHY ........................................................................................................... 233 CODE FOLDING ............................................................................................................... 234 22.17 SPLIT EDITING ................................................................................................................. 234 22.18 HYPERLINK NAVIGATION ................................................................................................ 235 22.19 22.20 NAVIGATION BUTTONS .................................................................................................... 235 22.21 REFACTORING ................................................................................................................. 235 SEARCH BAR ................................................................................................................... 236 22.22 22.23 WEB SEARCH .................................................................................................................. 239 THE LARGE DATA EDITOR ............................................................................................. 241 EDITING PLAIN TEXT ....................................................................................................... 242 EDITING RTF .................................................................................................................. 243 EDITING XML ................................................................................................................. 243 EDITING HTML .............................................................................................................. 244 EDITING IMAGES ............................................................................................................. 244 EDITING HEX DATA ......................................................................................................... 245 INVOKING AN EXTERNAL VIEWER OR EDITOR .................................................................. 246 THE QUERY BUILDER ....................................................................................................... 248 CREATING A NEW SELECT STATEMENT ............................................................................ 248 23.1 23.2 23.3 23.4 23.5 23.6 23.7 24.1 23. 24.
PL/SQL Developer 13.0 User’s Guide 7 25. 26. 27. 24.2 24.3 24.4 24.5 25.1 25.2 25.3 25.4 27.1 27.2 27.3 MODIFYING AN EXISTING SELECT STATEMENT ................................................................ 251 MANIPULATING THE QUERY DEFINITION ......................................................................... 251 QUERY BUILDER PREFERENCES ...................................................................................... 252 QUERY BUILDER PLUG-INS ............................................................................................. 253 THE PL/SQL BEAUTIFIER ................................................................................................ 254 DEFINING THE OPTIONS ................................................................................................... 254 DEFINING THE RULES ...................................................................................................... 255 USING THE BEAUTIFIER ................................................................................................... 256 SUPPRESSING FORMATTING ............................................................................................. 256 THE PL/SQL CLIPBOARD ................................................................................................. 257 TEMPLATES ......................................................................................................................... 258 THE TEMPLATE WINDOW ................................................................................................ 258 USING A TEMPLATE ......................................................................................................... 259 CREATING AND MODIFYING TEMPLATES ......................................................................... 260 28. WINDOW LIST ..................................................................................................................... 263 29. DOCKABLE AND FLOATING TOOLS ............................................................................. 265 30. RIBBONS AND TOOLBARS ............................................................................................... 267 31. DOCUMENT INTERFACE .................................................................................................. 270 MULTIPLE DOCUMENT INTERFACE (MDI) ...................................................................... 270 SINGLE DOCUMENT INTERFACE (SDI) ............................................................................ 270 32. ORACLE FILE SYSTEM (OFS) .......................................................................................... 271 OFS MANAGER ............................................................................................................... 271 OFS USAGE ..................................................................................................................... 273 33. HELP SYSTEMS ................................................................................................................... 275 MS HELP FILES ................................................................................................................ 275 HTML MANUALS ............................................................................................................ 275 34. CUSTOMIZATION ............................................................................................................... 278 PREFERENCES .................................................................................................................. 278 WINDOW LAYOUT ........................................................................................................... 278 ON-LINE DOCUMENTATION ............................................................................................. 278 COMMAND-LINE PARAMETERS ........................................................................................ 280 SQL, PL/SQL AND COMMAND KEYWORDS ..................................................................... 283 PLUG-INS ........................................................................................................................ 283 34.1 34.2 34.3 34.4 34.5 34.6 31.1 31.2 32.1 32.2 33.1 33.2
8 PL/SQL Developer 13.0 User’s Guide
PL/SQL Developer 13.0 User’s Guide 9 1. 介绍 PL/SQL Developer 是一个为 Oracle 数据库开发存储程序单元的集成开发环境(IDE),使用 PL/ SQL Developer 可以方便地创建你的客户/服务器应用程序的服务器部分。主要的功能有: 最坏的情况是,到目前为止你可能一直是这样工作的: • •使用文本编辑器编写程序单元(过程、触发器等)。 •使用Oracle SQL*Plus编译源文件。 •如果有一个编译错误,你必须找到它在源文件的位置,纠正它,切换回SQL*Plus重新编 译,只发现下一个错误。 •使用SQL*Plus或应用程序的客户端部分测试程序单元。 •如果出现运行时错误,您也很难找到问题的原因并进行纠正。 •使用Explain Plan实用程序或tkprof优化SQL语句。 •要查看或修改数据库中的其他对象和数据,可以使用SQL*Plus或其他工具。 这些任务——编辑、编译、纠正、测试、调试、优化和查询——都可以在不离开PL/ SQLDeveloper IDE的情况下执行。此外,PL/SQL Developer还提供了其他一些工具,这些工具 在日常PL/SQL开发中非常有用。 编辑 PL/SQL Developer与任何其他严肃的开发环境一样,假设您将源文件存储在磁盘上。其他工具 只允许编辑数据库中的源代码,但不允许任何版本控制或部署方案。源文件可以通过 SQL*Plus运行,因此可以在不使用PL/SQL Developer的任何平台上部署它们。您可以通过标 准的多文档接口一次编辑多个文件。 编辑器为程序员提供了广泛的帮助。对SQL语句和PL/SQL语句有上下文敏感的帮助。我们都 遇到过这种情况:您开始键入substr,但是忘记了参数的确切含义。现在您只需点击F1,就可以 进入SQL Reference手册中相应的主题。表、视图和程序单元可以用同样的方式在编辑器内的 上卷窗口中为您描述。在编辑器中集成了一个代码助手,当您键入数据库对象的名称时,它 会自动显示数据库对象的信息,从而允许您浏览并从中选择元素。
分享到:
收藏