what is the meaning here?

Shell Programming and Scripting
1

#!/bin/sh

$ORACLE_HOME/bin/sqlplus -S $orauserid/$orapasswd@$oradb << _TMP
alter session set nls_date_format = 'YYYYMMDD HH24:MI';
set linesize 100
set pagesize 400

ok the above is part of a script..i just wanna know what does sqlplus -S means?? as in why we need to insert the -S behind?

2

-S is to login to the sqlplus with SILENT option.

This suppresses all SQLPlus information and prompt messages, including the command prompt, the echoing of commands, and the banner normally displayed when you start SQLPlus.

If you omit username or password, SQL*Plus prompts for them, but the prompts are not visible.

3

thanks a miilion!