iSQL*Plus logo

Previous Page
Previous

Next Page
Next

Table Of Contents
Contents

Index
Index

User Interface

Overview

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.

Architecture

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.

Web Browser

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.

iSQL*Plus Server

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.

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.

Navigation

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

Icons

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

The following icons are displayed in iSQL*Plus screens (including online help):

Logout icon Logout

Logs you out of the iSQL*Plus session and returns you to the Login screen.

Login icon New Session

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.

History icon History

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.

Preferences icon Preferences

Opens the iSQL*Plus Preferences screen where you can set interface options, system variables or change your password.

Help icon Help

Opens the iSQL*Plus Help in a separate web browser window.

Next icon Next

Takes you to the next page in iSQL*Plus Help.

Previous icon Previous

Takes you to the previous page in iSQL*Plus Help.

Contents icon Contents

Takes you to the contents in iSQL*Plus Help.

Index icon Index

Takes you to the index in iSQL*Plus Help.

Breadcrumbs

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.

Login Screen

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

http://machine_name.domain:7777/isqlplus

The Login screen is displayed:


Text description of loginscn.gif follows.
Text description of the illustration loginscn.gif

Username:

Enter a valid username to connect to Oracle9i.

Password:

Enter a valid password for the username.

Connection Identifier:

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:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.oracle.com)
(PORT=1521)))(CONNECT_DATA=((SERVICE_NAME=orashop.us.acme.com))

Login

Click the Login button to log in to iSQL*Plus with the supplied username, password and connection identifier.

Work Screen

After successfully logging in, the Work screen is displayed.


Text description of work.gif follows.
Text description of the illustration work.gif

File or URL:

Enter the path and filename or the URL of a file you want to load into the Input area for editing or execution.

Browse...

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.

Load Script

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 statements:

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.

Execute

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.

Save Script

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.

Clear Screen

Click the Clear Screen button to clear all statements in the Input area, and all displayed output.

Cancel

Click the Cancel button to interrupt the script that is currently running.

History Screen

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.


Text description of histscn.gif follows.
Text description of the illustration histscn.gif

Script

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.

Load

Loads the selected scripts into the Input area of the Work screen.

Delete

Deletes the selected scripts from History.

Cancel

Cancels the History screen without making further changes or loading a script from History.

Preferences Screen

The Preferences screen allows you to set interface options and system variables, and to change your password.


Text description of prefscn.gif follows.
Text description of the illustration prefscn.gif

Set interface options

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".

Set system variables

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".

Change your password

Click Change your password or the adjacent Go button to access the Change Password screen. See "Changing Your Password".

Go

You can click the link or the Go button to navigate to the associated screen.

OK/Cancel

Click either the OK or the Cancel button to return to the iSQL*Plus Work screen.

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 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:

http://machine_name.domain:7777/isqlplusdba

The following dialog box is displayed prompting you to enter your Oracle HTTP Server authentication username and password.


Text description of httpauth.gif follows.
Text description of the illustration httpauth.gif

User Name

Enter a valid Oracle HTTP Server authentication username. This may not the same as your Oracle9i username.

Password

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:


Text description of lgdbascn.gif follows.
Text description of the illustration lgdbascn.gif

Username:

Enter a valid username to connect to Oracle9i.

Password:

Enter a valid password for the username. Your password is not displayed, asterisks are displayed for each character entered in the password field.

Connection Identifier:

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:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www.oracle.com)
(PORT=1521)))(CONNECT_DATA=((SERVICE_NAME=orashop.us.acme.com))

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.

Privilege:

The Privilege dropdown list has two options:

Login

Click the Login button to log in to iSQL*Plus with the supplied username, password, connection identifier and DBA privilege.

DBA Work Screen

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.


Text description of workdba.gif follows.
Text description of the illustration workdba.gif

 

iSQL*Plus Extension for Microsoft Windows

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.

Context Menu

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.


Text description of isenew.gif follows.
Text description of the illustration isenew.gif

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"

Previous Page
Previous

Next Page
Next

Table Of Contents
Contents

Index
Index