what does this statement do ?

[Striker99]

All,

Could any explain to me what this sql statemene does please.

sqlplus -s system/manager >/dev/null <set echo on

Thanks,
striker99

 

[freedomUSA]

Found a script with the following comment - hope this helps.
Its the most similar thing I could find since I was curious and echo on also displays on the screen.

# Note: To diagnose problems in the following PL/SQL script, change the
# following sqlplus invocation line to: sqlplus $USERPW <<!EOD
# in order to display any error messages to the screen. Note that you will
# also see a log of line continuation counters - This is normal when running
# SQL*Plus via a Unix &quot;here document&quot;.
#
sqlplus -s $USERPW >/dev/null<<!EOD

 

[freedomUSA]

hope this helps.
Did you pull this command out of an existing script?
Breaking it down - it calls sqlplus and the -s is
-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.
Use SILENT to invoke SQL*Plus within another program so
that use of SQL*Plus is invisible to the user.

then the dev/null sends it to nowhere land and the set echo on would display information to the screen.

found this in a script from the web:
# Note: To diagnose problems in the following PL/SQL script, change the
# following sqlplus invocation line to: sqlplus $USERPW <<!EOD
# in order to display any error messages to the screen. Note that you will
# also see a log of line continuation counters - This is normal when running
# SQL*Plus via a Unix &quot;here document&quot;.
#
sqlplus -s $USERPW >/dev/null<<!EOD

 

[rcurva]

This will run your sqlplus script without echoing anything in the screen.


Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War

 

[freedomUSA]

why does it say set echo on instead of set echo off?