Working With Objects
When you select an object, SQL Navigator enables all the appropriate menu or toolbar commands. The available actions vary depending upon the type of object selected.
| Icon | Tool | Description | ||
|---|---|---|---|---|
 |
Double click on an object to open it for editing.
| |||
 |
The Oracle DESCRIBE command reports the attributes, methods and arguments of an object type. With the SQL Navigator Describe command you can describe not only procedures, functions, packages, synonyms, and object types, but also tables, indexes, clusters and objects. | |||
 |
SQL Navigator editing tools for database objects. | |||
 |
Maintain SQL and PL/SQL code. Execute SQL queries. Debug PL/SQL code, prepare test data, run stored programs against the database, and immediately view the results. Compilation errors are precisely highlighted. | |||
 |
View chained rows information. | |||
 |
|
Edit data in a table object. It is possible to display and edit multi byte data. National Language Support can be applied to data in the Table Editor and Code Editor | Data Grid (SQL Query Results Data Grid). |
Copy an object from one schema to another
- Open a second DB Navigator window.
- Drag the object from the source window to the target window.
- Execute the DDL displayed in the editing window