SQL Navigator for Oracle 7.6 - User Guide

CTRL+B

The main menu bar can be floating or docked.

The following windows are dockable. They can be docked to any side of the SQL Navigator application window or any other dockable window. You can dock several windows to the same site.

• Auto Describe Tool
• Code Assistant
• Output Window
• Project Manager
• Source Preview
• Task Manager

Dockable windows open in the same state (floating or docked) and in the same screen position or at the same site as when they were last closed. Dockable windows retain size and position between sessions.

The size and location of dockable windows are remembered in screen layouts as per View Menu | Screen Layout.

The toolbars can be docked to any side of the SQL Navigator application window or can float on top of the current window.

1. If the toolbar is docked, click the down arrow to the far right of the toolbar.

   If the toolbar is floating, click the down arrow on the title bar.

2. Click Add or Remove Buttons.
3. Select the buttons to show.

1. If the toolbar is docked, click the down arrow to the far right of the toolbar.

   If the toolbar is floating, click the down arrow on the title bar.

2. Click Add or Remove Buttons | Customize.

Your Oracle username to the database.

When Save Password is selected the username field automatically recalls username/password combinations based on the first letter(s) entered into the field.

Your Oracle password to the database/username combination.

Select to save the password for this database/username combination.

Allow the system to automatically detect the number of bytes per character for the connection or select from the list of available numbers.

The default preference is set in View | Preferences | General | Session. If you receive ORA-01026 errors (or similar) when working with the database, we recommend setting this preference to the minimum possible value (2, 3 or 4) that eliminates the errors.

Select the type of system privileges you want to use for this connection—Normal, SYSDBA, or SYSOPER.

Your Username must first be granted these privileges. For information about system privileges, see the Oracle Database Administrator’s guide.

For more information, see DBA Dictionary Views.

Your Username must first be granted appropriate Oracle privileges.

When selected, SQL Navigator generates a log file of database operations and results. Quest Support may request you enable trace for troubleshooting purposes.

Enabling Trace slows down your access to the database.