SQL * Plus reference

SQL * Plus: Release 10.2.0.3.0-production on Thursday June 3 13:59:35 2010

Copyright (c) 1982,200 6, Oracle. All rights reserved.

SQL * Plus: Release 10.2.0.3.0-Production

Copyright (c) 1982,200 6, Oracle. All rights reserved.

Usage 1: sqlplus-H |-V

-H: displays the SQL * Plus version and
Usage help.
-V displays the SQL * Plus version.

Usage 2: sqlplus [[<option>] [<logon>] [<Start>]

<Option>: [-C <version>] [-L] [-M "<Options>"] [-r <level>] [-S]

-C <version> sets the compatibility of affected commands
<Version> the specified version. This version has
"X. y [. Z]" format. For example,-C 10.2.0
-L only try to log on once, instead
Prompt again when an error occurs.
-M "<Options>" sets the output automatic HTML Tag. Option
Format:
HTML [ON | off] [head text] [body text] [Table text]
[Entmap {on | off}] [spool {on | off}] [pre [format] {on | off}]
-R <level> sets the restricted mode to disable
SQL * Plus command. Level
Is 1, 2, or 3. The maximum limit is-R 3.
Disable file system interaction
All USER commands.
-S sets the no-Prompt mode, which is hidden
Command SQL * Plus mark, prompt and echo
.

<Logon>: (<username> [/<password>] [@ <connect_identifier>] | /)
[As sysdba | as sysoper] |/nolog

Specify the database account username, password, and database connection
. If no connection exists
Identifier. SQL * Plus is connected to the default database.

The options as sysdba and as sysoper are database management.
Permission.

/Nolog options enable SQL * Plus instead of connecting
Database.

<Start> is: @ <URL >|< FILENAME> [. <ext>] [<parameter>...]

Use the specified parameter that will be assigned to the substitution variable in the script
From the Web server (URL) or local file system (filename. ext)
Run the specified SQL * Plus script.

After SQL * Plus is started and the connect command is executed
File (for example, $ ORACLE_HOME/sqlplus/admin/glogin. SQL) and user profile
(For example, login. SQL in the working directory ). These files
It can contain the SQL * Plus command.

For more information, see the SQL * Plus User Guide and reference.