Interactive SQL consists of two panes:
SQL statements pane – This is where you enter SQL text to be processed. To run the SQL text, select either SQL | Execute, or the F5 function key. If the query takes a long time to process, Interactive SQL displays a screen describing the reasons why the query may be running slowly.
The SQL Statements pane contains a column on the left that shows line numbers. These line numbers allow you to do the following:
Select a line Click a line number to select a line. Alternatively place your cursor in the line, and press Ctrl+comma(,).
Select multiple lines Click and drag to select multiple lines.
Select a statement Double-click a line to select the entire SQL statement that corresponds to the line. Alternatively place your cursor in the statement, and press Ctrl+period(.).
Results pane – This pane displays the result of the run query. It always shows the Messages tab if you enable set show plan.The Messages tab displays messages from the database server about the SQL statements that you execute in Interactive SQL.You can configure settings for the tabs and panes in Interactive SQL using the Options menu found under Tools | Options.