1 SQL*Plus User Interface

This chapter describes the SQL*Plus command-line user interface, the Windows Graphical User Interface (GUI), and the iSQL*Plus web-based user interface. It contains the following topics:

SQL*Plus Command-line User Interface

The SQL*Plus command-line interface is standard on all operating systems.

The Command-line Screen

The following image shows the SQL*Plus command-line interface running in an X terminal.

Description of cmdline.gif follows
Description of the illustration cmdline.gif

When SQL*Plus starts, it displays the date and time, the SQL*Plus version and copyright information before the SQL*Plus prompt appears. The default prompt for SQL*Plus command-line is:

SQL>

Changing the Command-line Font and Font Size

In Windows, from a Command Prompt, open the Command Prompt Properties dialog to set the font and font size used in the SQL*Plus command-line interface.

To Change the Command-line Interface Font and Font Size

  1. Right click in the command-line interface title bar.

  2. Click Properties. The Window Preview box displays the current window's relative size on your monitor based on your font and font size selections. The Selected Font: box displays a sample of the current font.

  3. Click the Font tab.

  4. Select the font size to use from the Size box. Raster font sizes are shown as width by height in pixels. TrueType font sizes are shown as height in pixels.

  5. Select the font to use from the Font box.

  6. Select the Bold Fonts check box if you want to use a bold version of the font.

For more information about changing Command Prompt properties, see Windows Help or click Help in the Command Prompt Properties dialog.

Using a Special Character in Windows

To check if a font contains a particular character, for example, the Euro sign, enter the character's decimal number equivalent in the SQL*Plus command-line interface. For example, the decimal number equivalent for the Euro sign is 128, so you would enter Alt+0128 (hold Alt while pressing 0, 1, 2 and 8 in the numeric keypad) to display it. If it appears correctly, the font contains the Euro sign, otherwise you need to try another font.

You can use the Windows Character Map utility to view the characters available in a font. Character Map also shows the decimal number equivalent for extended ASCII characters. You access the Character Map utility by selecting Start, Programs, Accessories and then clicking Character Map.

Windows Graphical User Interface

The graphical user interface is a feature of SQL*Plus only available in Windows. The Windows Graphical User Interface will be obsoleted in favor of the iSQL*Plus browser-based user interface in a future release of SQL*Plus.

The graphical user interface does not support non-blocking database calls to the Oracle Database server. Therefore there is no cancel dialog while statements are executing.

The following image shows the SQL*Plus Windows Graphical User Interface (GUI) running in Windows.

Description of wingui.gif follows
Description of the illustration wingui.gif

When the Windows GUI starts, it displays the same information as the command-line user interface, and has the same default prompt:

SQL>

Using the Mouse to Copy Text to the Command Prompt

You can use the mouse to copy text from anywhere in the Windows GUI to the SQL*Plus prompt.

Left click and drag to select the text you want to copy. While still holding down the left button, right click to copy the selected text to the SQL*Plus prompt.

You can also use Ctrl-C and Ctrl-V to cut and copy text.

Using Command Keys

The following command keys have special functions in the Windows GUI:

Key Function
Home Top of screen buffer
End Bottom of screen buffer
Page Up Previous screen page
Page Down Next screen page
Ctrl+Page Up Show page on left of current screen page
Ctrl+Page Down Show page on right of current screen page
Alt+F3 Find
F3 Find next
Ctrl+C Cancels the data fetch operation following command execution.
Ctrl+C Copies text - when no operations are running.
Ctrl+V Paste text
Shift+Del Clear the screen and the screen buffer

Using the Windows GUI Menus

There are menus in the SQL*Plus Windows GUI menu bar. In the Option column, entries in parentheses show keyboard shortcuts. The Command-line column shows equivalent command-line commands.

File Menu

The File menu has the following options:

Option Description of File Menu Option Command-line
Open The Open option retrieves a previously stored script

If you supply no file extension, SQL*Plus looks for scripts with the SQL extension The script should contain a single SQL or PL/SQL statement such as SELECT It should not contain multiple statements, and it should not contain SQL*Plus commands such as SET.

 GET filename
Save The Save option has three alternatives: Save Create, Save Replace, and Save Append SAVE
 
  • Save Create saves the contents of the SQL*Plus buffer in a script By default, SQL*Plus assigns the SQL extension to scripts You can specify a different extension in the File name text box.

  • Save Replace replaces the contents of an existing file with the contents of the SQL*Plus buffer SQL*Plus creates the file if it does not exist.

  • Save Append adds the contents of the SQL*Plus buffer to the end of the file you specify.

 SAVE filename CREATE

SAVE filename REPLACE

SAVE filename APPEND
  After you save a script, you can:

  • Retrieve the file using the Open option on the File menu.

  • Edit the file using the Editor option on the Edit menu.

  • Run the file using the START or RUN commands from the SQL*Plus command prompt.

  
Save As The Save As option saves the contents of the SQL*Plus buffer in a script.

By default, SQL*Plus assigns the SQL extension to scripts.You can specify a different extension in the File name text box.

 SAVE filename REPLACE
Spool The Spool option has two alternatives:Spool File and Spool Off The Spool File option is the same as the SPOOL command with the REPLACE option SQL*Plus for Windows does not support the SPOOL OUT option.  
 
  • Spool File stores query results in a file By default, SQL*Plus assigns the LST extension to spool files You can specify a different extension in the File name text box You can edit the results with the Editor option on the Edit menu, and print the file from a Windows text editor.

  • Spool Off turns off spooling.

 SPOOL filename REP:ACE

SPOOL OFF
Run The Run option lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. Typically this will be the last statement that was executed. RUN
Cancel(Ctrl+C)) The Cancel option cancels an in-progress operation.

The Cancel keyboard shortcut is only available when a SQL operation is running in the SQL*Plus session. When no SQL*Plus operation is running, Ctrl+C copies selected text.

 Ctrl+C
Exit The Exit option commits all pending database changes and closes the SQL*Plus application window. EXIT

Edit Menu

The Edit menu has the following options:

Option Description of Edit Menu Option Command-line
Copy(Ctrl+C) The Copy option copies selected text to the Clipboard

After you copy text to the Clipboard, you can paste the text into other Windows applications, such as Microsoft Excel and Microsoft Word.

The Copy keyboard shortcut is only available when no SQL operations are running in the SQL*Plus session When a SQL operation is running, Ctrl+C cancels the running operation.

 not applicable
Paste(Ctrl+V) The Paste option pastes the contents of the Clipboard to the SQL*Plus command-line.

Note: A maximum of 3625 characters can be pasted from the Clipboard to the SQL*Plus command-line during a single paste operation.

 not applicable
Clear (Shift+Del) The Clear option clears the screen buffer and the screen of the SQL*Plus application window. CLEAR SCREEN
Editor The Editor option has two alternatives: Invoke Editor and DefineEditor.  
 
  • InvokeEditor loads the contents of the SQL*Plus buffer into an editor. By default, SQL*Plus saves the file to AFIEDT.BUF

  • Define Editor defines the editor that is invoked

 EDIT

DEFINE _EDITOR =editor_name

Search Menu

The Search menu has the following options:

Option Description of Search Menu Option Command-line
Find(Alt+F3) The Find option searches for a character, a word, or a group of characters or words in the SQL*Plus application window. Find begins the search at the top of the displayed screen.

Note: When Find reaches the end of the displayed screen, it does not wrap and continue searching from the top of the screen buffer.

 not applicable
Find Next (F3) The Find Next option finds the next occurrence of the search text. not applicable

Options Menu

The Options menu has the following options:

Option Description of Options Menu Option Command-line
Environment The Environment option enables you to set system variables to alter the SQL*Plus environment for your current session. This dialog has three areas: Set Options, Value, and Screen Buffer.

Note: See Setting Options and Values Using the Environment Dialog for examples of how these controls interact.

  
  Set Options

This area has a list of variables you can select to establish aspects of the SQL*Plus environment for your current session, such as:

  • Setting the display width for NUMBER data.

  • Setting the display width for LONG data.

  • Enabling or disabling the printing of column headings.

  • Setting the number of lines in each page.

See the SET command for descriptions of each system variable.

 SET variable value
  Value

The Value area has four options: Default, Custom, On, and Off.

Note: When Custom is selected, the On and Off buttons and the text field may or may not be enabled for user selection. The availability of these fields depends on the item selected in the Set Option.

 SET variable value
  Screen Buffer

This area has two text boxes: Buffer Width and Buffer Length.

 not applicable
 
  • Use the Buffer Width text box to set the number of characters available to display on one line. The Buffer Width value must be at least as big as the LINESIZE value. Buffer Width has a default value of 100, a minimum value of 80, and a maximum value of 32,767 characters.

  • In the Buffer Length text box, you set the number of lines that SQL*Plus displays on the screen. The default value of the Buffer Length parameter is 1000 lines. You can specify from 100 to 2000 lines on one screen.

  
  Notes: When you change the Screen Buffer option, SQL*Plus displays a dialog to alert you that if you shorten the size of your screen buffer, some data may not be displayed on your screen Click OK to proceed.  
  If you use SET MARKUP to send output to an HTML table, the number of lines specified in the Buffer Length variable specifies the number of HTML table rows Each HTML table row may contain more than one text line.  

Help Menu

The Help menu has the following option:

Option Description of Help Menu Option Command-line
About SQL*Plus Displays the SQL*Plus version number and copyright information.

You access SQL*Plus help from the SQL*Plus prompt. See Getting Command-line Help.

 not applicable

Changing the Windows GUI Font and Font Size

There are two registry entries that set the font and font size used in the SQL*Plus Windows GUI. SQLPLUS_FONT sets the font face, and SQLPLUS_FONT_SIZE sets the font size in pixels.

You use the Windows Registry Editor to create these two registry entries and define values for them. Ensure that you create the correct entries in uppercase, and that the values (font names, sizes) you enter are correct.

Warning:

Microsoft does not recommend modifying the registry. Editing the registry may affect your operating system and software installation. Only advanced users should edit the registry. Oracle takes no responsibility for problems arising from editing the Windows registry.

You can choose any fixed-pitch TrueType font available in your Windows system such as Courier New or Lucida Console. If you choose a proportional pitch font such as Arial or Times New Roman, or if you enter an unavailable font, the registry entry is ignored and the default font and size, Fixedsys 16, are used. If you choose an unavailable font size, the default font size, 16, is used.

If you do not create the SQLPLUS_FONT registry entry, or if you do not specify a value for SQLPLUS_FONT, the default font and size, Fixedsys 16, are used.

If you want to use particular characters, such as the Euro sign, you should make sure that the fixed pitch font you choose contains those characters.

To Change the Windows GUI Font and Font Size

  1. Select Run from the Start menu and then enter regedit in the Open field.

  2. Click OK to start the Registry Editor. The Registry Editor is displayed.

  3. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0.

    Note:

    If you have more than one Oracle Database installation, you must select the HOME entry associated with the Windows GUI you want to change. HOME0 is the registry entry for an Oracle Database installation. A subsequent Oracle Database installation will have the registry entry HOME1 and the next HOME2 and so on.

    Changes only affect a SQL*Plus Windows GUI started from the associated Oracle Database installation, so you can use different settings for each Oracle Database installation.

  4. Click New String Value in the Edit menu. A new string value, with the default name, NewValue #1 is created at the bottom of the right pane of the Registry Editor. The default name of the new string value is selected ready for you to replace with the name you want.

  5. Enter SQLPLUS_FONT as the name of the new font face string value. If you misskey the name or inadvertently enter it in mixed or lower case, you can edit the name by selecting Rename from the Edit menu.

    or

    Enter SQLPLUS_FONT_SIZE as the name of the new font size string value. If you misskey the name or inadvertently enter it in mixed or lower case, you can edit the name by selecting Rename from the Edit menu.

  6. Click Modify from the Edit menu or press Enter again to display the Edit String dialog.

  7. Enter the font name you want to use, such as Courier New, in the Value Data: field. SQL*Plus will use the new font the next time you start the SQL*Plus Windows GUI. The font must be a True Type fixed pitch font such as Courier New or Lucida Console.

    or

    Enter the font size you want to use in pixels, such as 14, in the Value Data: field. SQL*Plus will use the new font size the next time you start the SQL*Plus Windows GUI. The size must be a size that exists on the client machine for the specified font.

    Note:

    You should not change the font face, font size or font subset while any SQL*Plus Windows GUI is active. You should exit all SQL*Plus Windows GUI sessions, make font face, font size and font subset changes in the registry, exit the Registry Editor and then restart the SQL*Plus Windows GUI to see the changes.

Using a Special Character

To check if a font contains a particular character such as the Euro sign, enter the character's decimal number equivalent in the SQL*Plus Windows GUI. For example, the decimal number equivalent for the Euro sign is 128, so you would enter Alt+0128 (hold Alt while pressing 0, 1, 2 and 8 on the numeric keypad) to display it. If it appears correctly, the font contains the Euro sign, otherwise you need to try another font.

You can also use the Windows Character Map accessory to view the characters available in a font. Character Map also shows the decimal number equivalent for extended ASCII characters. You access the Character Map accessory by selecting Start->Programs->Accessories->System Tools->Character Map.

iSQL*Plus User Interface

iSQL*Plus is a web-based user interface to an Oracle Database.

iSQL*Plus Navigation

There are a number of ways to navigate in iSQL*Plus:

Icons

Global navigation icons are displayed on each screen. Icons have two states:

  • A white background when that functionality is available

  • A blue background when active (when you have navigated to that screen)

Three navigation icons are always available after you have logged into iSQL*Plus:

Logout
logout.gif is an image of the iSQL*Plus Logout Icon

Deletes your history list, ends your iSQL*Plus session, and displays the Login screen with a message confirming that you have logged out.

Preferences
prefs.gif is an image of the iSQL*Plus Preferences Icon

Opens the Preferences screen where you can configure interface settings, system settings or change your password.

Help
help.gif is an image of the iSQL*Plus Help Icon

Opens iSQL*Plus Help in a separate web browser window. Help is also available from the Login screen.

Tabs

Tabs appear on the top right of the current screen. Click a tab to go to that screen.

Menus

There are side menus to provide navigation to sections in screens such as Preferences. Click the link to go to that screen.

Footer Links

Footer links are navigation links to available screens shown at the bottom of each page. Click a link to go to that screen.

iSQL*Plus Login Screen

You connect to the Login screen from your web browser with a URL like:

http://machine_name.domain:port/isqlplus

The Login screen is displayed:

Description of login.gif follows
Description of the illustration login.gif

Username:

Enter a valid username to connect to the Oracle Database (mandatory).

Password:

Enter a valid password for the username (mandatory).

Connection Identifier:

Leave this field blank to use the default Oracle database, otherwise enter a connection identifier for the database you want to connect to.

[//]host[:port][/service_name]

The SERVICE_NAME is the global database name entered during database creation. It combines a database name with a domain name. For example, the SERVICE_NAME sales.us.acme.com has a database name of sales and a domain of us.acme.com.

An INSTANCE_NAME is the name you give to the database instance during creation. It defaults to the SID you entered during database creation.

An Oracle System Identifier (SID) identifies a specific Oracle release 8.0 or earlier database instance.

You can optionally use an INSTANCE_NAME in place of the SERVICE_NAME.

Use a SID in place of SERVICE_NAME when connecting to an Oracle release 8.0 database.

Alternatively you can use an Oracle Net alias. If you use an Oracle Net alias, it must be specified on the machine running the iSQL*Plus Server, which may not be the same machine from which you run your web browser.

iSQL*Plus can be configured to restrict connections to specific databases. If restricted database access has been enabled, a dropdown list of available databases is displayed in place of the Connection Identifier text field. This enables greater security for iSQL*Plus Servers in hosted environments. This is configured using the iSQLPlusConnectIdList parameter in the configuration file. See Enabling Restricted Database Access for more information.

See the Oracle Database Net Services Administrator's Guide for more information about defining connection identifiers.

Login

Click the Login button to log in to iSQL*Plus. If you enter an invalid username or password, the Login screen is re-displayed with an error message.

iSQL*Plus DBA Login Screen

You can log in to iSQL*Plus with SYSDBA or SYSOPER privileges to perform database administration and run DBA commands through iSQL*Plus. You must authenticate with the Application Server, and have Oracle SYSDBA or SYSOPER privileges.

To connect with either SYSDBA or SYSOPER privileges, users must be created through the OC4J user manager. To add users for DBA Login, see Enabling iSQL*Plus DBA Access.

Because of possible HTTP network timeouts, it is recommended that you use command-line SQL*Plus for long running DBA operations.

To log in with SYSDBA or SYSOPER privileges, you must enter the iSQL*Plus DBA URL in the Location/Address field of your web browser. The iSQL*Plus DBA URL is in the form:

http://machine_name.domain:port/isqlplus/dba

The Enter Network Dialog dialog is displayed. The name of the dialog may differ on different operating systems.

Description of jaznauth.gif follows
Description of the illustration jaznauth.gif

User Name

Enter a valid Application Server authentication username. This may not be the same as your Oracle Database username.

Password

Enter a valid Application Server authentication password for the username. This may not be the same as your Oracle Database password.

After you have successfully authenticated, the iSQL*Plus DBA Login screen is displayed:

Description of login_dba.gif follows
Description of the illustration login_dba.gif

Username:

Enter a valid username or / to connect to Oracle Database (mandatory).

Password:

Enter a valid password for the username.

Connection Identifier:

Leave this field blank to use the default Oracle database, otherwise enter a connection identifier for the database you want to connect to.

[//]host[:port][/service_name]

You can optionally use INSTANCE_NAME in place of SERVICE_NAME. When connecting to an Oracle release 8.0 or earlier database, you use a SID. Alternatively you can use an Oracle Net alias. If you use an Oracle Net alias, it must be specified on the machine running the iSQL*Plus Server, which may not be the same machine from which you run your web browser.

iSQL*Plus can be configured to restrict connections to specific databases. If restricted database access has been enabled, a dropdown list of available databases is displayed in place of the Connection Identifier text field. This enables greater security for iSQL*Plus Servers in hosted environments. This is configured using the iSQLPlusConnectIdList parameter in the configuration file. See Enabling Restricted Database Access for more information.

Privilege:

The Privilege dropdown list has two options:

  • SYSDBA—connects to the specified database with SYSDBA privileges.

  • SYSOPER—connects to the specified database with SYSOPER privileges.

Login

Click the Login button to log in to iSQL*Plus with the supplied username, password, connection identifier and DBA privilege. If you enter an invalid username or password, you are returned to the Login screen and a message is displayed.

iSQL*Plus Workspace

The Workspace consists of the Workspace, History and Load Script screens. After successfully logging in, the Workspace is displayed. From the Workspace you can:

  • Enter, Execute and Cancel scripts

  • Load and Save scripts

  • View, Save and Print output

  • Access Preferences screens

  • Get help and Log out

Description of workspace.gif follows
Description of the illustration workspace.gif

The Workspace and History screens display the user's connection information in the top right. The connection information is displayed in the form:

Connected as [username]@[connection_identifier] [AS SYSDBA| AS SYSOPER]

or

Not connected

Clear

Clears all statements in the Input area, and all displayed output. Cancels any script that may be running.

It does not clear the SQL buffer, nor does it clear any variable values altered by changing preferences or changing options of the SET command.

Execute

Executes the contents of the Input area. Depending on your preference settings, the results are displayed in the Output area, in a new web browser window, or saved to a file.

Load Script

Displays the Load Script screen where you enter a path and file name, or a URL for the script you want to load into the Input area for editing or execution.

Save Script

Displays the File > Save As dialog where you enter a file name for the script you want to save from the Input area as a plain text file. It may be useful to identify scripts with an extension of .SQL.

Cancel

Cancels any script that is currently running, but does not clear the Input or Output areas. A message saying that the script was cancelled is displayed.

Next Page

Displays the next page of report output. The Next Page button is displayed when there are more results to display than can fit on the current output page or the script contains a PAUSE command.

You can configure whether pages are displayed on a single page or multiple pages using Preferences > Interface Configuration > Output Page Setup, or by executing the SET PAUSE ON or SET PAUSE OFF command.

You can use the standard Back button of your web browser to view previous pages of iSQL*Plus output. Some web browsers do not support this use of the Back button.

iSQL*Plus DBA Workspace

If you log in with SYSDBA or SYSOPER privileges, the iSQL*Plus DBA Workspace is displayed to remind you of the privileged connection. It is otherwise identical to the iSQL*Plus Workspace described earlier.

Fill out the fields on the DBA Workspace as you would for the iSQL*Plus Workspace.

iSQL*Plus History Screen

Click the History tab to display the History screen. The History screen enables you to reload scripts that you have previously executed in the same session.

A history entry is created each time you execute a script in the Workspace if it is not the same as the most recently executed script. The History screen shows the first 80 characters of the script.

When the history limit is reached, the oldest scripts are removed. When you exit a session the history is discarded, and history is not shared between sessions.

You can change the default number of entries stored in the history list in the Interface Options screen which you access from the Preferences screen.

Description of history.gif follows
Description of the illustration history.gif

Script

Shows the current list of scripts in the history. They are in most recently executed order, with the most recent at the top. Click the checkbox of one or more scripts that you want to load into the Input area.

Scripts are displayed verbatim, so be careful if you have included items like CONNECT commands which include passwords.

Load

Loads the selected scripts into the Input area of the Workspace.

Delete

Deletes the selected scripts from the history.

Click the Workspace tab to return to the Input area without loading or deleting any scripts from the history.

iSQL*Plus Input Required Screen

When iSQL*Plus executes a script containing substitution variables, the Input Required screen is displayed for each substitution variable. For example, enter:

BREAK ON &&SORTCOL
SELECT &SORTCOL, SALARY
FROM &MYTABLE
WHERE SALARY > 12000
ORDER BY &SORTCOL;

The Input Required screen is displayed.

Description of inputreq.gif follows
Description of the illustration inputreq.gif

Enter Value for sortcol

Enter a value for the sortcol variable. For example, enter LAST_NAME. Remember that if a substitution variable is currently undefined, then when it is referenced with a single ampersand, you are prompted for its value at every occurrence of the reference. If you reference the variable with a double ampersand, the value is retained for the session and you will only be prompted for it once.

When prompted, enter a value for the mytable variable. For example, enter EMP_DETAILS_VIEW.

Continue

Click the Continue button to execute the script in the Input area with the input values you entered.

Cancel

Click the Cancel button to cancel execution of the script and return to the Workspace.

iSQL*Plus Preferences Screen

The Preferences screen enables you to change interface settings, system settings, and your password. The Cancel and Apply buttons appear on each of the Preferences screens and have the same function on all Preferences screens. Click the Workspace or History tab to return to the Workspace or History screen.

Connection information is not displayed in the Preferences screen.

Cancel

Click the Cancel button to cancel changes you have made on this Preferences screen.

Apply

Click the Apply button to apply the changes you have made on this Preferences screen.

Interface Configuration

Click Interface Configuration in the side menu to open the Interface Configuration screen.

Description of prefs_interface_config.gif follows
Description of the illustration prefs_interface_config.gif

System Configuration

You can click one of the three entries under System Configuration in the side menu to open these further three screens:

  • Script Formatting

  • Script Execution

  • Database Administration

Script Formatting

Click Script Formatting in the side menu to open the Script Formatting screen. You use the Script Formatting screen to set options that affect the way script output is displayed.

Each of these options contains either a field, set of radio buttons, or text area to change the setting, with explanatory text.

Description of prefs_script_format.gif follows
Description of the illustration prefs_script_format.gif

Script Execution

Click Script Execution in the side menu to open the Script Execution screen. You use the Script Execution screen to set options which affect the way scripts are executed.

Each of these options contains either a field, set of radio buttons, or text area to change the setting, with explanatory text.

Description of prefs_script_exec.gif follows
Description of the illustration prefs_script_exec.gif

Database Administration

Click Database Administration in the side menu to open the Database Administration screen. You use the Database Administration screen to set options that affect database administration.

Each of these options contains either a field, set of radio buttons, or text area to change the setting, with explanatory text.

Description of prefs_dba.gif follows
Description of the illustration prefs_dba.gif

Change Password

Click Change Password in the side menu to access the Change Password screen. See Changing Your Password in iSQL*Plus.

Description of prefs_password.gif follows
Description of the illustration prefs_password.gif

Preferences and Equivalent SET Commands

The tables below show the preferences available on each of the four Preferences screens, and the equivalent system variables that can be set using the SET command.

Table 1-1 Interface Configuration

iSQL*Plus Preference Equivalent SET Command

History Size

Not applicable

Input Area Size

Not applicable

Output Location

Not applicable

Output Page Setup

SET PAGESIZE, SET PAUSE

Table 1-2 Script Formatting

iSQL*Plus Preference Equivalent SET Command

Describe Objects

SET DESCRIBE

Display Bind Variables

SET AUTOPRINT

Display Commands

SET ECHO

Display Headings

SET HEADING

Display Record Count

SET FEEDBACK

Display Server Output

SET SERVEROUTPUT

Display Substitution Variables

SET VERIFY

*HTML HEAD Tag

SET MARKUP HTML HEAD

*HTML BODY Tag

SET MARKUP HTML BODY

*HTML TABLE Tag

SET MARKUP HTML TABLE

Line Size

SET LINESIZE

*Map Special Characters to HTML Entities

SET MARKUP HTML ENTMAP

Null Text

SET NULL

Number Format

SET NUMFORMAT

Number Width

SET NUMWIDTH

Preformatted Output

SET MARKUP HTML PREFORMAT

Column Separator

SET COLSEP

Display Record Separator

SET RECSEP, SET RECSEPCHAR

Headings on Multiple Lines

SET HEADSEP

Underline Headings

SET UNDERLINE

Start Output

SET EMBEDDED

Timing Statistics

SET TIMIMG

Wrap Lines

SET WRAP

* Items prefixed with an asterisk are only available when the iSQLPlusAllowUserMarkup configuration option is set to ALL. Its default value is NONE. For more information, see Enabling User Defined HTML Markup.

Table 1-3 Script Execution

iSQL*Plus Preference Equivalent SET Command

Array Size

SET ARRAYSIZE

Check SQL Syntax

SET FLAGGER

Commit Changes

SET AUTOCOMMIT

Commit when Copying

SET COPYCOMMIT

Compare Datatypes when Copying

SET COPYTYPECHECK

Escape Character

SET ESCAPE

LOB Offset

SET LOBOFFSET

LOB, LONG and XML Type Size

SET LONG

Multiple SQL*Plus Commands on Single Line

SET CMDSEP

Register Scripts

SET APPINFO

SQL and PL/SQL Terminator

SET BLOCKTERMINATOR

SQL Case

SET SQLCASE

SQL Compatibility

SET COMPATIBILITY

SQL Terminator

SET SQLTERMINATOR

SQL*Plus Compatibility

SET SQLPLUSCOMPATIBILITY

Substitution Variable Prefix

SET DEFINE

Substitution Variable Reference Terminator

SET CONCAT

Trace Statements

SET AUTOTRACE

XQuery Base URI

SET XQUERY BASEURI

XQuery Ordering

SET XQUERY ORDERING

XQUERY Node Identity

SET XQUERY NODE

XQUERY Context

SET XQUERY CONTEXT

Table 1-4 Database Administration

iSQL*Plus Preference Equivalent SET Command

Archive Log Source

SET LOGSOURCE

Automatic Recovery

SET AUTORECOVERY