SQL*Plus Quick Reference
Release 8.1.6

A75665-01

Library

Product

Prev Up Next

SQL*Plus Quick Reference, 3 of 10


Starting and Leaving SQL*Plus

Use the following commands to log in to and out of SQL*Plus.

SQLPLUS [[option] [logon] [start]]

where option has the following syntax:

- | -? | [ [-M[ARKUP] "mark_options"] [-R[ESTRICT] {1|2|3}] 
[-S[ILENT]] ]

where mark_options has the following syntax:

     HTML [ON|OFF] [HEAD text] [BODY text] [ENTMAP {ON|OFF}]
          [SPOOL {ON|OFF}]  [PRE[FORMAT] {ON|OFF}]

where logon has the following syntax:

username[/password][@net_service_name]|/|/NOLOG

and where start has the following syntax:

@file_name[.ext] [arg ...]
{EXIT|QUIT} [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK]

      Commits all pending changes, terminates SQL*Plus, and returns control to the operating system.


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product