This tab allows you to configure the appearance of text typed in the SQL Statements pane.
The Editor tab of the Options dialog in Interactive SQL consists of four tabs: Editor, Tabs, Format, and Print.
The Editor tab has the following components:
The Tabs tab has the following components:
Insert spaces Inserts n spaces when you press Tab instead of inserting one tab character. The value for n will be between one and the number of indent size spaces, depending on how many spaces are required to move the cursor forward to the next tab stop. This is enabled by default.
The Format tab has the following components:
Text Highlighting Lets you specify the color and style of different types of text in the main editing window. Choose a type of text and then set the foreground, background, and style for that text type.
The Print tab has the following components:
Header Lets you specify what information appears in the header, as well as how it is formatted, when you print the contents of the SQL Statements pane. The header text is left aligned by default. Press the > button for a list of available options.
Footer Lets you specify what information appears in the footer, as well as how it is formatted, when you print the contents of the SQL Statements pane. The footer text is left aligned by default. Press the > button for a list of available options.
The items that you select do not all need to have the same alignment. For example, you can choose to left align the file name and right align the date in the header. By default, all text in both the header and the footer is left aligned. You must specify the alignment before the type of text. For example, if you want the file name to be centered in the header, type &C&F in the Header field, or press the > button and select the Center option and then press the > button again and select the Filename option.
In addition to specifying these options, you can type text that you want to appear in the header and footer fields. For example, if you type Page &P of &p in the Footer field, Page 1 of 1 appears in the footer of the printed document.
Interactive SQL provides a text completion option that can supply object names for you. You can configure text completion to fill in the name of any or all of the following object types: tables, views, columns, stored procedures, and system functions.
To use text completion:
In Interactive SQL, type the first letter of a database object name in the SQL Statements pane.
Press Ctrl+Space or Ctrl+Shift+Space.
A window appears listing the names of database objects that begin with the letters you have typed so far.
If you do not see the object name you want, press Tab to view a complete list of database objects. By default, all database objects appear in the list.
The object name appears in the SQL Statements pane.
Select the object name from the list and then press Enter.