|
Quick tour of SQL Navigator
Welcome to SQL Navigator
The SQL Navigator user interface
Using the virtual work area
Easy browsing and object navigation
Fast access to any object
Instant access to your `favorites'
Menus and commands for handling database objects and code
Visual editors for database objects
Powerful SQL Editor
Drag-and-drop Query Builder
Complete execution environment for stored programs
Complete and extensible code template libraries
PL/SQL Debugger
Team coding and Version Control support
Graphic profiler for optimizing stored programs
Web development support
Reporting tools
How to find the help you need
Who should use SQL Navigator?
Oracle version support
Entering your authorization key
Copyright Information
New features
What's new in SQL Navigator 4?
Getting access to new features
Interface Enhancements
Interface Enhancements
Customizable menus and toolbars
Docking toolbars and windows
Saving window layouts
Synchronized menus and toolbars
Simplified menus and toolbars
Improved Preferences setup
Drag-and-Drop enhancements
Personalized workspaces for developers
New Task Bar for easier window-switching
Quick detail view of any object
Auto-Describe feature
Automatic Source Preview
Easier switching between sessions
Speedy selection of database objects
Oracle Job Manager integration
Integration with DataFactory and Benchmark Factory
Easier database browsing
Comprehensive online Help with enhanced navigation aids
Editing Enhancements
All-in-one SQL Editor
Improved PL/SQL Editor for stored programs with powerful new Code Explorer
Automatic Code Completion
Begin/End markers for loops and blocks
Dot-lookup for record members
Hyperlinking to database objects
Easy switching between implementation and declaration
Improved syntax highlighting
Integrated PL/SQL Profiler (Oracle 8.1.5+)
New Query Results window
Source Code Search utility enhancements
Extract DDL enhancements
Debugger enhancements
Debugger enhancements
Context-sensitive tooltip description for identifiers
Multi-paged Output window
Execution code generation enhancements
New and improved development tools
Formatter Plus
Describe tool enhancements
Easier viewing of data in database objects
Object Data Viewer
Support for LOBs (large objects)
Support for Oracle 8 partitioned tables and indexes
New and enhanced Visual Object Editors
User can set default schema for object editors
Code Assistant enhancements
Query Builder enhancements
Improved Team Coding facilities
Improved Team Coding facilities
General and Miscellaneous enhancements
Faster, more efficient execution
More complete Oracle 8/8i support
Multi-threaded task execution
More convenient Logon routine
Improved date/time representation and handling
More stable, easier to maintain
Superceded functionality
The SQL Navigator interface
Overview
Overview of the SQL Navigator interface
Main windows
The Task Bar
Using the virtual work area
Managing windows
Saving window layouts
Dragging objects to a hidden window
Accessing functions and tools
Connecting to the Oracle Database
Navigating the database with DB Navigator
Personalized workspaces for developers
Finding objects quickly
Displaying a schema object and its properties
Managing database objects
Performing actions on a selected schema object
Oracle Data Dictionary views
Menus, Toolbars, & Commands
Menus
Saving Window Layouts
Command locator
Customizing menus and toolbars
Toolbars
Toolbars
The Team Coding Toolbar
The Session toolbar
The Object Toolbar
The Functions Toolbar
The Edit Toolbar
The Debug Toolbar
Keyboard shortcuts
Keyboard shortcuts by functional category
Keyboard shortcuts combined list
General Shortcuts
Navigation Shortcuts
Editing Shortcuts
Preferences Shortcuts
Programming shortcuts
Debugging Shortcuts
Code editors overview
Code editors overview
SQL Editor overview
The Stored Program Editor
Workspaces: A smarter way of working
Workspaces: A smarter way of working
The workspace window
Managing workspaces
Managing workspaces
To create a workspace
To open a workspace
To add an object or file to the current workspace
To add a code location shortcut to a workspace
Saving connection shortcuts in your Workspace
To connect to a database from the workspace
To filter the list of objects in a workspace
To open a workspace object or file
To view or update objects in a workspace
To remove an object or file from a workspace
Invoking the Describe command for a workspace object
Context-sensitive commands in workspaces
Setting preferences
Saving window layouts
Working with code templates and shortcuts
Setting SQL Navigator preferences
To display the Preferences dialog
Setting general preferences
User Interface preferences
Dockable Output Window
"Drop" and "Truncate" safety options
Session preferences
Default Tables preferences
Drag and drop coding preferences
Explain Plan preferences
Code Assistant preferences
Printing preferences
Object editor preferences
Debugger preferences
Extract DDL preferences
Extract DDL Table/View Specific preferences
Extract DDL/Partitioning preferences
Workspace preferences
Code Editor preferences
SQL Editor Preferences
Stored Program Editor Preferences
General Code Editor Preferences
LOB Viewer preferences
Difference viewer preferences
Team Coding preferences
Team Coding File Extension Options
Team Coding General options
Managing Oracle connections and Instance parameters
Connecting to the Oracle Database
Setting Instance initialization parameters
Managing sessions
To switch to another session
To reopen an inactive DB Navigator window
To create a new connection
Saving connection shortcuts in your Workspace
To connect to a database from the workspace
Disconnecting from an Oracle instance
Connecting using Net8
Connecting Using Connect Strings
Connecting using command line parameters
Connecting to Personal Oracle
Connecting to a database within the SQL Editor
To close a connection
To activate another session in another window
Troubleshooting Connections to Oracle
Navigating the database
Navigating the database
The DB Navigator window
DB Navigator commands
DB Navigator commands
To move around in the Navigator window
To expand a node in the DB Navigator
To collapse a node in the DB Navigator
To expand the selected node and all its descendants
To refresh the entire tree from the database
Working with objects in the DB Navigator
Finding and opening objects in the DB Navigator
Quickly finding objects in any schema
Viewing the contents of a DB Navigator tree node
Finding objects by search argument
Displaying an object's place in the schema
Browsing or editing table data from the DB Navigator
To apply filters to restrict the object types displayed for a session
To display the shortcut menu
To perform an action on a database object
To view or hide details about the node selected
To create a database object
To edit a database object
To drop a database object
To rename a database object
To compile an object
To compile an object and all its dependent objects
To browse or edit table data from the DB Navigator
To build a query from a selected table
To extract DDL and display it in the SQL Editor
To invoke the DESCRIBE command for an object
To view or edit database object definitions
To execute a stored program
DB Navigator drag-and-drop tips
To drag database object names into an editor
To add a code location shortcut to a workspace
To add an external file to the current workspace
To add an object to a workspace
To add an object to the Query Builder work area
To copy an object from one schema to another
To open an external file in SQL Editor
To open an object in an editor
Viewing server output
Viewing server output
To display the Output window
To make the Output window dockable
To change size of the buffer for server output
To print Output window contents
To copy and paste selected text from the Output window
Working with SQL statements and scripts
Writing and editing SQL code
Getting started with the SQL Editor
SQL Editor overview
Opening the SQL Editor
Editing SQL statements and scripts
Editing SQL code
The SQL window
SQL window toolbar buttons
SQL window shortcut menu commands
Point-and-click column names from any object
Using the Describe tool to drag column names into code
The Output window
Inserting code from another file
Inserting ready-made code segments via shortcut keys
Code templates and their assigned shortcuts
SQL*PLUS command support
Validating syntax
Automatic indentation
Gutter markers in the code editors
Begin/End markers for loops and blocks
Using Bookmarks in the SQL Editor
Previewing an object's source code
Formatting source code
Dragging names of database objects into code
Using substitution variables for flexible SQL statements
Using Bind variables
Debugging a variable in the SQL Editor
Integrated impact analysis and quality assurance
Entering multiple SQL statements
Inserting a text file
Entering PL/SQL blocks
Tuning with the Explain Plan tool
Tuning with the Explain Plan tool
Analyzing queries with Explain Plan
Viewing an Operation Description
To execute an Explain Plan for a SQL Statement
Tuning a SQL script
To change default preferences for the Explain Plan tool
Edit toolbar quick-reference
Intro
Copying selected text
Create a DBMS_OUTPUT.PUT_LINE statement
Jumping to a specified line
Indenting and unindenting
Inserting a CRUD matrix
Inserting ready-made code from templates
Recalling SQL
Using bookmarks
Undo or Redo your editing operations
Customizing the SQL Editor
Setting SQL Editor Preferences
Working with code templates and shortcuts
Customizing SQL Editor toolbars
Fast query building with the Query Builder
Overview of the Query Builder
Fast query building with the Query Builder
The Query Builder window
Query Builder quick reference
To build a query
To set rules, options or criteria for a query
Customizing Query Builder
Automated query-building
Code catalogs for fast and easy coding
Code catalogs for fast and easy coding
Using code catalogs and the Code Assistant
Automatically starting Code Assistant with Editors
Viewing information about catalog objects
Adding, editing or deleting catalog items
Saving your SQL statements and code in catalogs
Use catalogs to save and re-use your SQL statements and code
Viewing Describe information
Executing SQL and working with results
Executing SQL statements and working with results
Executing a SQL script
Executing SQL statements
To execute the SQL statements displayed in the SQL Editor
To execute an individual SQL statement
SQL window execution status pane
Running multiple queries
Running the same script against different databases
Updateable queries
Executing updateable queries
To submit an updateable query
To run an updateable query
The Spool window
The Spool window
To display SQL statements in the Spool window
Retrieving previously executed SQL statements
Spooling results as text
To view results in text form
To view results in text form
To view the text of a memo field
The Result display
Viewing query results
Result display of the SQL Editor
Result window commands and toolbars
Formatting query result columns
Exporting query results
To display the details of a selected record
To display multiple rows in a data sheet format
To sort the data sheet
To fetch sets of rows
Copying data from the Result display
Printing query results
Restricting the columns displayed in the results grid
Switching between SQL code and results
To switch between SQL code and results using accelerator keys
Selecting, inserting and deleting results data
To jump between a query and its results page
To jump to the associated results tab
Viewing objects, collections, or reference columns in relational tables
Viewing results in text format
Working with PL/SQL code
Overview
Working with PL/SQL
Working with packages
Tools and commands for editing stored programs
Tools and commands for editing stored programs
Advanced editing features for stored programs
Controlling what is displayed in the Stored Program Editor
Managing stored programs as database objects
Editing code in stored programs
Complete and extensible code template libraries
Automated coding assistance
Searching for code or objects in the database
Using other SQL Navigator windows with the Stored Program Editor
Managing your editing session
Access to tools and add-ons for stored program development
Synchronize advanced editing features
Viewing compilation errors
The Knowledge Xpert
Knowledge Xpert Catalogs
PL/Vision Control Panel settings
The Knowledge Xpert library
Knowledge bases
Writing and editing stored programs
Creating a new stored program
Modifying a stored program
To insert a saved text file into the Stored Program Editor
Using the Code Explorer
Gutter markers in the code editors
Begin/End markers for loops and blocks
Inserting ready-made code segments via shortcut keys
Using bookmarks
Programmable keys for PL/SQL code
Saving and re-using code
Viewing compilation errors
Compiling a stored program
Correcting syntax errors
Drag-and-drop PL/SQL editing
Using the Describe tool to drag column names into code
Correcting typing errors
Customizing color highlighting for PL/SQL and SQL keywords
Converting HTML into a PL/SQL stored procedure
Previewing an object's source code
Testing program code
Executing stored programs
Executing stored programs
Creating anonymous blocks
Setting execution code parameters
Profiling options
Viewing results in the Output window
Viewing an Oracle error description and solution
Stepping though stored programs
Running stored programs in Debug mode
Optimizing stored programs: The PL/SQL Profiler
Profiler overview
Using the PL/SQL Profiler with the Stored Program editor
Locating an open procedure in the database structure
Optimizing stored programs
PL/SQL Profiler quick-reference guide
PL/SQL Profiler: Basic concepts
Installing the PL/SQL Profiler
PL/SQL Profiler window
Interpreting the result sets
Interpreting PL/SQL Profiler result sets
Setting PL/SQL Profiler filters and sort options
Setting PL/SQL Profiler group properties
Optimizing stored programs
Debugging PL/SQL
Overview of the PL/SQL Debugger
Debugging PL/SQL
Using the DBMS_OUTPUT package as an aid to debugging
Debugging PL/SQL with the SQL Navigator Debugger
Using the SQL Navigator debugger
Debugging stored procedures
Oracle version requirements for the Debugger
Setting watched variables
A brief glossary of debugging terms
Initiating a debugging session
Debugging code run from an external application
Setting and viewing Breakpoints
Controlling code execution in the debugger
Evaluating and modifying variables
Troubleshooting the SQL Navigator Debugger
Debugging PL/SQL
Debugger quick reference
Debugger quick reference
To continue execution to the first executable line of a procedure or trigger (or to the nex
To debug code run from an external application
To display watches for a program unit
To execute the current line without tracing into an associated trigger trigger
To include debug information in the compiled procedure
To initiate debugging
To modify a variable
To pause automatic execution
To repeatedly perform the Step over function at intervals
To repeatedly perform the Trace Into function at a set interval
To run other sessions while debugging
To run to cursor location.
To set a breakpoint in your code
To set breakpoints from an editor
To set debugging options
To set watches
To step out of the current procedure and into the outer procedure that called it
To stop the execution of the stored program
To view current execution point
To view current values of variables
To view the current execution stack and all breakpoints and watches
Working with HTML and Java
Creating HTML pages
Overview of Web development support
Oracle Web Development
Creating HTML pages
Web Server Overview
Requirements for using SQL Navigator Web support
Starting the Web Server
Converting a Stored Procedure into HTML
Generating HTML output
Sample code for displaying query results in an HTML page
Setting up local image directories
Printing a Web page
Converting an HTML file into a PL/SQL stored procedure
Converting an HTML file into a PL/SQL stored procedure
Working with Java
Working with Java
Using the Java Editor
Using the Java Manager to load and unload Java
Publishing Java to PL/SQL
Extracting DDL from Java source
Working with database objects
Visual editors for database objects
Fast access to any object
Easy browsing and object navigation
Finding and opening a database object
Opening two or more instances of the same object editor
Displaying a schema object and its properties
Performing actions on a selected schema object
Creating, altering or copying database objects
Creating new objects
Automatically compile all dependent objects
Modifying existing objects
Dropping a database object
Extracting DDL and other SQL statements from objects
Commands for editing database objects
Constraints
Indexes
Database links
Sequences
Synonyms
Packages
Procedures
Views
Profiles
Users
Roles
Varying arrays (VARRAYs)
Clusters
Tables
Tables
Optimizing tables
Populating tables using DataFactory
Editing nested tables
Triggers
Editing triggers
About triggers
Debugging triggers
Tools for analysis and tuning
Tools for analysis and tuning
Tuning with the Explain Plan tool
Analyzing database structures
Version Control and Team Coding
Team Coding overview
Team coding and Version Control support
Team Coding and version control
Support for Version Control products
Using Team Coding features
Viewing and changing objects' Team Coding status
To set a filter for the Team Coding Viewer
Team Coding status in editor status bar
Team Coding Status codes
Terms and abbreviations
Checking objects and scripts in and out
Getting the latest revision
Entering comments with check-in or check-out
Browsing version control archives
Viewing file differences
To view differences for selected objects
Responding to the Different Files dialog
Viewing Team Coding user status
Installing Team Coding options
Installing Team Coding options
Install server-side objects