Sql*Plus User’s Guide and Reference


Exiting SQL*Plus Command-line


Download 5.34 Mb.
Pdf ko'rish
bet43/103
Sana04.08.2023
Hajmi5.34 Mb.
#1665146
1   ...   39   40   41   42   43   44   45   46   ...   103
Bog'liq
E18404-12

Exiting SQL*Plus Command-line
If you cannot log in to SQL*Plus because your username or password is invalid or for 
some other reason, SQL*Plus returns an error status equivalent to an EXIT FAILURE 
command. See the 
EXIT
command on page 12-60 for further information.
When you are done working with SQL*Plus and wish to return to the operating 
system, enter EXIT or QUIT at the SQL*Plus prompt, or enter the end of file character, 
Ctrl+D on UNIX or Ctrl+Z on Windows.
SQL*Plus displays the version of Oracle Database from which you disconnected and 
the versions of tools available through SQL*Plus before you return to the operating 
system prompt.
SQLPLUS Program Syntax
You use the SQLPLUS command at the operating system prompt to start 
command-line SQL*Plus:
SQLPLUS [ [
Options
] [
Logon
|/NOLOG] [
Start
] ]
where: 
Options
 has the following syntax: 
-H[ELP]|-V[ERSION]
|[[-C[OMPATIBILITY] {
x
.
y
[.
z
]] [-L[OGON]] [-M[ARKUP] 
markup_option
]
[-NOLOGINTIME] [-R[ESTRICT] {1|2|3}] [-S[ILENT]] ]
[-NOLOGINTIME]
and markup_option has the following syntax:
SQL*Plus: Release 12.1.0.1.0 Development on Fri Aug 3 19:03:02 2012
Copyright (c) 1982, 2012, Oracle. All rights reserved.
Last successful login time Wed Aug 1 20:30:05 2012
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0......


SQLPLUS Program Syntax
Starting SQL*Plus
3-7
HTML [ON|OFF] [HEAD 
text
] [BODY 
text
] [TABLE 
text
] [ENTMAP {ON|OFF}]
[SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
where 
Logon
has the following syntax:
{
username
[/
password
][@
connect_identifier
]| / }
[AS {SYSASM|SYSBACKUP|SYSDBA|SYSDG|SYSOPER|SYSKM}][edition=
value

where 
Start
has the following syntax:
@{
url
|
file_name
[.
ext
]} [
arg
...]
You have the option of entering logon. If you do not specify logon but do specify start
SQL*Plus assumes that the first line of the script contains a valid logon. If neither start 
nor logon are specified, SQL*Plus prompts for logon information.

Download 5.34 Mb.

Do'stlaringiz bilan baham:
1   ...   39   40   41   42   43   44   45   46   ...   103




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling