Table 3-1: Keyboard
shortcuts
Function
|
Description
|
|---|
ALT+F4
|
Exits Interactive SQL.
|
ALT+LEFT
CURSOR
|
Displays the previous SQL statement in the history list.
|
ALT+RIGHT CURSOR
|
Displays the next SQL statement
in the history list
|
CTRL+C
|
Copies the selected row(s) and column
headings to the clipboard.
|
CTRL+END
|
Moves to the bottom of the current pane.
|
CTRL+F6
|
Cycles through the open Interactive SQL windows.
|
CTRL+H
|
Displays the history of your executed SQL statements during the current
session.
|
CTRL+HOME
|
Moves to the top of the current pane.
|
CTRL+N
|
Clears the contents of the Interactive SQL window.
|
CTRL+Q
|
Displays the Query Editor, which helps
you build SQL queries. When
you have finished building your query, click OK to
export it back into the SQL Statements
pane.
|
CTRL+S
|
Saves the contents of the SQL Statements pane.
|
SHIFT+F5
|
Refreshes the plan without executing
the statement in the SQL Statements
pane. This allows you to see the plan for a statement without altering
table data.
|
ESC
|
Clears the SQL Statements
pane.
|
F2
|
Allows you to edit the selected row in
the result set. You can use the Tab key to move from column to column
within the row.
|
F5
|
Executes all text in the SQL Statements pane. You can also
perform this operation by clicking the Execute SQL Statement
button on the toolbar.
|
F7
|
Displays the Lookup Table Name dialog.
In this dialog, you can find and select a table and then press Enter
to insert the table name into the SQL Statements
pane at the cursor position. Or, with a table selected in the list,
press F7 again to display the columns in that table. You can then
select a column and press Enter to insert the column name into the SQL Statements pane at the cursor
position.
|
F8
|
Displays the Lookup Procedure Name dialog.
In this dialog, you can find and select a procedure, then press
Enter to insert the procedure name into the SQL Statements
pane at the cursor position.
|
F9
|
Executes the selected text in the SQL Statements pane. If no text is
selected, all of the statements are executed.
|
Page down
|
Moves down in the current pane.
|
Page up
|
Moves up in the current pane.
|
