Sql*Plus User’s Guide and Reference
Options The following sections contain descriptions of SQLPLUS command options: HELP Option
Download 5.34 Mb. Pdf ko'rish
|
E18404-12
- Bu sahifa navigatsiya:
- LOGON Option
- MARKUP Options -M[ARKUP] Warning: Including your password in plain text is a security risk.
Options
The following sections contain descriptions of SQLPLUS command options: HELP Option -H[ELP] Displays the usage and syntax for the SQLPLUS command, and then returns control to the operating system. VERSION Option -V[ERSION] Displays the current version and level number for SQL*Plus, and then returns control to the operating system. COMPATIBILITY Option -C[OMPATIBILITY] {x.y[.z] Sets the value of the SQLPLUSCOMPATIBILITY system variable to the SQL*Plus release specified by x.y[.z]. Where x is the version number, y is the release number, and z is the update number. For example, 9.0.1 or 10.2. For more information, see the SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]} on page 12-148. LOGON Option -L[OGON] Specifies not to reprompt for username or password if the initial connection does not succeed. This can be useful in operating system scripts that must either succeed or fail and you don't want to be reprompted for connection details if the database server is not running. MARKUP Options -M[ARKUP] Warning: Including your password in plain text is a security risk. You can avoid this risk by omitting the password, and entering it only when the system prompts for it. SQLPLUS Program Syntax 3-8 SQL*Plus User's Guide and Reference You can use the MARKUP option to generate a complete stand alone web page from your query or script. MARKUP currently supports HTML 4.0 transitional. Use SQLPLUS -MARKUP HTML ON or SQLPLUS -MARKUP HTML ON SPOOL ON to produce standalone web pages. SQL*Plus will generate complete HTML pages automatically encapsulated with and tags. The HTML tags in a spool file are closed when SPOOL OFF is executed or SQL*Plus exits. The -SILENT and -RESTRICT command-line options may be useful when used in conjunction with -MARKUP. You can use MARKUP HTML ON to produce HTML output in either the tag or in an HTML table. Output to a table uses standard HTML
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