Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

like to ignore the -s "silent" option from Sql*Plus

ErikYkemaSep 25 2009 — edited Sep 28 2009
Hi there,
Is there a way to ignore the -s option to Sql*Plus?
I don't want to to change existing code (i.e. ksh scripts) that tend to call sqlplus with the -s option, for silent (reducing output) - and I want to see that output!

I was thinking about writing a custom shell script 'sqlplus' that removes the -s command line parameter, and then forwards the call and the commandline, however I must see whether that also works when the Sql*Plus workload is piped or cat-ed in - as the ksh scripts tend to do.

Studied the Sql*Plus manual, however couldn't find it.

Thanks,
Erik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2009
Added on Sep 25 2009
5 comments
800 views