Drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code.
Code Snippets are stored in catalogs. The catalogs are as follows.
Catalog | Description | ||
---|---|---|---|
Syntax and Web Catalog | Browse the ready-to-use library of PL/SQL syntax. The Knowledge Xpert gives SQL Navigator users a library of more than 900 pre-built PL/SQL routines that can eliminate hours of low-level coding and debugging while enhancing application performance and reliability. | ||
PL/Vision Catalog | Knowledge Xpert products are available as optional add-on modules. For more information, see Search Knowledge Xpert. | ||
Code and SQL Catalog |
Store your own frequently used SQL statements and code fragments here. For example, you can store your frequently-used cursor declarations or variable declarations.
|
Icon | Tool Tip | Description | ||
---|---|---|---|---|
Add new item or node |
Add a code snippet or SQL statement. Open the Add to Catalog / Edit Dialog. | |||
Edit item or node |
Edit the selected item. Open the Add to Catalog / Edit Dialog.
| |||
Delete item or node |
Delete the selected item.
| |||
Paste snippet into editor |
Use to paste a code snippet into an editor:
| |||
Show information window |
Show/Hide the information pane. The information pane shows detailed information on the selected item. | |||
Capture code |
Use to add a code snippet or SQL statement from an editor window into the catalog:
This opens the Add to Catalog / Edit Dialog with the selected code already inserted. | |||
Save all catalogs to disk |
Save changes. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center