What is -s option in sqlplus used for?
Per the documentation:
-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 script. The SQL*Plus banner and prompts are suppressed and do not appear in reports created using the SILENT option.
pOrinG
Updated on June 04, 2022Comments
-
pOrinG almost 2 years
Am little new to shell script and would like to know the use of -s option [sqlplus -s] in shell script.
Thanks in advance.