SQL*Plus Release 9.0.1 Enhancements

SQLPLUS Command Line Switches

The version and usage command line switches have been standardized as:

-V[ERSION]
-H[HELP]

Invalid options give the usage message corresponding to -HELP. The "-" and "-?" options have been obsoleted.

iSQL*Plus

iSQL*Plus is a browser-based interface to SQL*Plus. iSQL*Plus is only available on the Microsoft Windows operating system in this release. For more information on iSQL*Plus, see the iSQL*Plus User's Guide and Reference, A88826-01.

START, @, @@

New commands were added to read and execute a SQL script from a Uniform Resource Identifier (URI). The ability to read and execute a script from a URI is available in the @, @@ and START commands. The syntax is:

@{uri|file_name[.ext]} [arg...]
@@file_name[.ext]
STA[RT] {uri|file_name[.ext]} [arg...]

"uri" specifies a script to run on the specified web server. SQL*Plus supports HTTP, FTP and gopher protocols. Pass variable values to the script in the usual way, for example:

http://host.domain/script.sql value1 value2

Note: This feature is only available on Microsoft Windows.

SET APPINFO

The default for SET APPINFO is now OFF. This allows some privileged DBA operations to be executed when the database is not fully configured. Add SET APPINFO ON to glogin.sql to get the previous behavior.

SET SQLPLUSCOMPATIBILITY

There is a new SET command, SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}. It sets the behavior of the VARIABLE command to that of the version specified by SQLPLUSCOMPATIBILITY.

In later releases of SQL*Plus, SQLPLUSCOMPATIBILITY may support features other than VARIABLE. The SQLPLUSCOMPATIBILITY command can be used to help keep the expected behavior of a release.

HR Sample Schema

The SQL*Plus documentation uses a new set of sample schemas for all examples. See the Oracle9i Sample Schemas guide for details on access, implementation and use of the sample schemas.