SQL Navigator allows easy navigation of the relational database structure, with all major database objects and their relationships displayed in a convenient hierarchical interface—the DB Navigator.
Visualization of schema
Comprehensive visual representation of database schemas helps you work faster and smarter.
Supports Oracle 8/8i object types
The DB Navigator can display virtually all Oracle 8/8i object types, including object tables, collection types, directories, libraries, Java objects, nested tables, and table columns and type attributes of user-defined data. (DBA dictionary views are required for viewing some nodes of the DB Navigator tree.)
Partitioned tables and indexes
The DB Navigator supports Oracle 8 partitioned tables and indexes. Partitions are displayed under corresponding partitioned tables or indexes, so you can browse them individually. The Extract DDL function includes partition information when generating a script.
Drill-down on types
Types can be expanded in order to show details of their types and/or store tables
Selective viewing
SQL Navigator filters let you define preferences for viewing database objects for each database they are connected to, with unique filter sets associated to each preference.
Saved views
Viewing by object type and using schema elements with filters lets you zero in on objects of interest. You can save favorite filter combinations into a catalog of templates for later use.
Quick table browsing
SQL Navigator’s quick browser lets you view the contents of database tables and views in read-only mode, benefiting developers and DBAs alike. Even long fields and CLOBs can be viewed in a pop-up editor.
Create SQL in browser
SQL Navigator lets you create SQL queries to run against any table or view.