Database Journal SQLCourse SQLCourse2. Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? Forum Oracle Forums Oracle Database Administration suppress display.

sqlplus set command - Oracle - SScom

Page 1 of 2 1 2 Last Jump to page: Results 1 to 10 of Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode.

Join Date Mar Posts I need something to work like unix re-direction operator.

They should NOT be displayed on screen. I am using spool to do so, but need help with suppressing the results. I used the following set verify off set heading off set linesize set feedback off set termout off set term off spool out1.

It suppressed the screen display but not the query result. The records displayed as usual.

Is there anything else that I should add to the above? Join Date Sep Location Chicago, IL Posts TERMOUT is the answer. OFF suppresses the display so that you can spool output from a script without seeing the output on the screen.

Ask TOM "Command to inhibit display of SQL*PLUS results on "

ON displays the output. TERMOUT OFF does not affect output from commands you enter interactively. I used this sequence of commands: Basically, I want to spool the records to a text file Is this the right way? Join Date Nov Location greenwich.

Oracle SqlPlus - saving output in a file but don't show on screen - Stack Overflow

Jeff Hunter marist89 yahoo. Hanky View Profile View Forum Posts. Join Date Jan Posts 3, TERMOUT needs to be in the script to work.

Actually I am wrong. SET TERMOUT will suppress the display on a called script. Sorry, that was a browser problem I tried Marist's script and it worked well.

etygivusyx.web.fc2.com

Hanky your script seems to be the same. Thanks for the tip. I don't know why TERMOUT is not working here. Once again, from the Doc: Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle: How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited.

All times are GMT The time now is Forum Oracle Forums Oracle Database Administration suppress display If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: To start viewing messages, select the forum that you want to visit from the selection below.

Results 1 to 10 of 12 Thread: Hanky View Profile View Forum Posts X-Mas poo Join Date Jan Posts 3, TERMOUT needs to be in the script to work. MH I remember when this place was cool.

Hanky View Profile View Forum Posts X-Mas poo Join Date Jan Posts 3, Actually I am wrong. Reply With Quote Page 1 of 2 1 2 Last Jump to page: