iSQL*Plus is a browser-based interface to Oracle9i. It is a component of the SQL*Plus product.
iSQL*Plus enables you to use a web browser to connect to Oracle9i and perform the same tasks as you would through the command line version of SQL*Plus. You can use iSQL*Plus to write SQL*Plus, SQL and PL/SQL commands to:
Different web browsers, and the size of the web browser window, may affect the appearance and layout of iSQL*Plus screens.
iSQL*Plus is a fast, browser-based interface which uses the SQL*Plus processing engine in a three-tier model comprising:
The three tiers may or may not be on the same machine. The iSQL*Plus Server must be on the same machine as the Oracle HTTP Server. The middle tier coordinates interactions and resources between the client tier and the database tier. The database tier is Oracle9i, which is accessed via Oracle Net.
The iSQL*Plus user interface runs in a web browser connected to the Internet or your intranet. There is no installation or configuration required for the iSQL*Plus user interface. You only need to know the URL of the Oracle HTTP Server to access Oracle9i.
The iSQL*Plus Server is installed with the Oracle HTTP Server when Oracle9i is installed. The middle tier contains the Oracle HTTP Server and the iSQL*Plus Server. The iSQL*Plus Server enables communication and authentication between the iSQL*Plus user interface and Oracle9i. Each iSQL*Plus session is uniquely identified, so you can have multiple concurrent sessions open to Oracle9i.
Oracle Net components provide communication between the iSQL*Plus Server and Oracle9i in the same way as for a client server installation of Oracle9i.
There are a number of ways to navigate in iSQL*Plus:
Global navigation icons are displayed on each screen. Icons have three states:
The following icons are displayed in iSQL*Plus screens (including online help):
Logs you out of the iSQL*Plus session and returns you to the Login screen.
Starts a new iSQL*Plus session in a separate web browser window. You can log in to the new session as the same user or as any other valid user.
Opens the iSQL*Plus History screen. You can select one or more previously executed scripts to reload into the Input area or to delete from the History list.
Opens the iSQL*Plus Preferences screen where you can set interface options, system variables or change your password.
Opens the iSQL*Plus Help in a separate web browser window.
Takes you to the next page in iSQL*Plus Help.
Takes you to the previous page in iSQL*Plus Help.
Takes you to the contents in iSQL*Plus Help.
Takes you to the index in iSQL*Plus Help.
Breadcrumbs are navigation links showing the navigation path you have taken. They appear as text links displayed under the iSQL*Plus logo. Click on a breadcrumb link to return to any of the screens listed. For example, navigating to the Preferences screen using the Preferences icon displays a Work screen breadcrumb.
Work Screen > Preferences
Click on the Work Screen link to return to the Work screen.
You connect to the Login screen from your web browser with a URL like:
The Login screen is displayed:
Enter a valid username to connect to Oracle9i.
Enter a valid password for the username.
Leave this field blank to use the default Oracle database if one exists, otherwise enter an Oracle Net alias to specify a remote database you want to connect to. If you use an Oracle Net alias, it must be defined on the machine running the iSQL*Plus Server, which may not be the same machine from which you run your web browser.
You can also use the full connection identifier, for example:
Click the Login button to log in to iSQL*Plus with the supplied username, password and connection identifier.
After successfully logging in, the Work screen is displayed.
Enter the path and filename or the URL of a file you want to load into the Input area for editing or execution.
Click the Browse... button to search for a script file that you want to load for editing or execution. When you select the file, its path and name are entered in the File or URL: field.
Click the Load Script button to load the script specified in the File or URL: field into the iSQL*Plus Input area for editing or execution.
Enter SQL statements, PL/SQL blocks, or iSQL*Plus commands. This area is also referred to as the Input area. You can resize the Input area in the Interface Options screen which you access from the Preferences screen.
Click the Execute button to execute the contents of the Input area. Depending on your preference settings, the results are displayed in the Work screen, in a new web browser window, or saved to a file.
Click the Save Script button to save the contents of the Input area to a file. You are prompted to enter the name of the file. The file extension you choose is for your convenience. It may be convenient to identify scripts with an extension of .SQL.
Click the Clear Screen button to clear all statements in the Input area, and all displayed output.
Click the Cancel button to interrupt the script that is currently running.
Click the History icon to display the History screen. The History screen allows 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 Work screen if it is not the same as the most recently executed script. The History screen shows the leading 80 characters of the script.
Once you load a script from History, it is moved to the top of the History list, and when the History limit is reached, the earliest scripts are removed. When you exit a session the History is lost, 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.
Shows the current list of scripts in History. They are in most recently executed order, with the most recent at the top. You click the script text to load it into the Input area.
Scripts are displayed verbatim, so be careful if you have included items like CONNECT commands which include passwords.
Loads the selected scripts into the Input area of the Work screen.
Deletes the selected scripts from History.
Cancels the History screen without making further changes or loading a script from History.
The Preferences screen allows you to set interface options and system variables, and to change your password.
Click Set interface options or the adjacent Go button to access the Interface Options screen. You use the Interface Options screen to set:
See "Setting User Interface Options".
Click Set system variables or the adjacent Go button to access the System Variables screen. You use the System Variables screen to set iSQL*Plus system variables. See "Setting System Variables".
Click Change your password or the adjacent Go button to access the Change Password screen. See "Changing Your Password".
You can click the link or the Go button to navigate to the associated screen.
Click either the OK or the Cancel button to return to the iSQL*Plus Work 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 Oracle HTTP Server, and have Oracle SYSDBA or SYSOPER privileges from the Oracle instance.
To connect with either SYSDBA or SYSOPER privileges, your username and password must be added to the Oracle HTTP Server authentication file. See "Adding Entries to an Oracle HTTP Server Authentication File".
Because of possible network timeouts, it is recommended that you use the Oracle Enterprise Manager 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:
The following dialog box is displayed prompting you to enter your Oracle HTTP Server authentication username and password.
Enter a valid Oracle HTTP Server authentication username. This may not the same as your Oracle9i username.
Enter a valid Oracle HTTP Server authentication password for the username. This may not the same as your Oracle9i password.
After you have successfully authenticated, the iSQL*Plus DBA Login screen is displayed:
Enter a valid username to connect to Oracle9i.
Enter a valid password for the username. Your password is not displayed, asterisks are displayed for each character entered in the password field.
Leave this field blank to use the default Oracle database if one exists, otherwise enter an Oracle Net connection identifier to specify a remote database you want to connect to. You can use the full connection identifier, for example:
You can optionally use
(INSTANCE_NAME=instance) phrase in place of the
(SERVICE_NAME=name) phrase. When connecting to an Oracle8 or earlier database, you use the
(SID=name) phrase. 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 allows greater security for iSQL*Plus Servers in hosted environments.
The Privilege dropdown list has two options:
Click the Login button to log in to iSQL*Plus with the supplied username, password, connection identifier and DBA privilege.
If you log in with SYSDBA or SYSOPER privileges, the iSQL*Plus DBA Work screen is displayed to remind you of the privileged connection.
Fill out the fields on the DBA Work screen as you would for the Work screen.
The iSQL*Plus Extension for Microsoft Windows provides a context menu to load or execute local SQL scripts in iSQL*Plus. The iSQL*Plus Extension works with .SQL files and is activated by right clicking a .SQL file in Windows Explorer.
The utility is installed during Oracle9i Database and Oracle9i Client for Windows installations. After installation, you can configure access to one or more iSQL*Plus Servers.
After you have configured an iSQL*Plus Server, you can use the context menu to:
The following shows a typical view of the context menu with iSQL*Plus Servers configured.
The highlighted iSQL*Plus Server is configured to start iSQL*Plus in a web browser and load emp_report.sql into the Input area of the iSQL*Plus Server named EmployeeDB_LA.
For information about configuring iSQL*Plus Servers in the iSQL*Plus Extension, see "Configuring the iSQL*Plus Extension"