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!

supress prompt in the output file

Asmirnov-OracleMay 14 2019 — edited May 15 2019

Hi,

Not sure if this is correct forum, but let me try please - how do I supress prompt in sqlplus from being written to a file when spooling, for example, in case

spool ....

select username from dba_users where rownum < &num;

spool off;

When executing the script in sqlplus i am getting this text in the output spool file:

Enter value for num: 8

What is sqlplus setting which will prevent this text to be written into spool?

Thanks,

Anatoliy

Comments
Post Details
Added on May 14 2019
3 comments
185 views