| sqlplus option [message #63113] |
Fri, 10 September 2004 01:00  |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
dear frnds
wht it means sqlplus -s option
how it comes silent(Is it -s means silent) what the advantage of
using this option(-s) in scripts.is it work in background
pls clarify
with regards
jon
|
|
|
|
| Re: sqlplus option [message #63115 is a reply to message #63113] |
Fri, 10 September 2004 01:28  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
You seem to be missing some vowels on your keyboard. No offence intended, of course ;-). It is hard to decrypt messages like this (I'm no native English speaker myself, which makes it even harder).
That said, I'll try to translate the question in plain English:
"What is the use of the -s option in sql*plus? Is it useful because it works on the background?"
To answer your question, here's an extract from the SQL*Plus User Guide and Reference:
----------------------------------------------------------------------
[[S]]ILENT Suppresses all SQL*Plus information and prompt messages, including
the command prompt, the echoing of commands, and the banner normally
displayed when you start SQL*Plus. If you omit username or password,
SQL*Plus prompts for them, but the prompts are not visible. Use
SILENT to invoke SQL*Plus within another program so that the use of
SQL*Plus is invisible to the user.
SILENT is a useful mode for creating reports for the web using the
SQLPLUS -MARKUP command inside a CGI script or operating system
command file. The SQL*Plus banner and prompts are suppressed and do
not appear in reports created using the SILENT option.
----------------------------------------------------------------------
HTH,
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
