Sql*Plus User’s Guide and Reference
Exiting SQL*Plus Command-line
Download 5.34 Mb. Pdf ko'rish
|
E18404-12
- Bu sahifa navigatsiya:
- SQLPLUS Program Syntax
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: |
Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling
ma'muriyatiga murojaat qiling