Home » SQL & PL/SQL » Client Tools » How to suppress the output? (Redhat 4 + oracle 10g R2)
How to suppress the output? [message #545193] Mon, 27 February 2012 20:26 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production

test.sql :

set wrap off
set linesize 100
set feedback off
set pagesize 0
set verify off
set termout off

spool /tmp/test.log

select lower(column_name)||'||chr(9)||'
from user_tab_columns
where table_name = upper('&1')
and column_id != ( select max(column_id)
from user_tab_columns
where table_name = upper('&1')
)
order by column_id
/

spool off



test.log :

Enter value for 1: big_table
Enter value for 1: big_table
id||chr(9)||
owner||chr(9)||
object_name||chr(9)||
subobject_name||chr(9)||
object_id||chr(9)||
data_object_id||chr(9)||
object_type||chr(9)||
created||chr(9)||
last_ddl_time||chr(9)||
timestamp||chr(9)||
status||chr(9)||
temporary||chr(9)||
generated||chr(9)||



I want to spool output to a file without displaying string in file as following. How to modify my test.sql file to do that?

Enter value for 1: big_table
Enter value for 1: big_table
Re: How to suppress the output? [message #545199 is a reply to message #545193] Mon, 27 February 2012 20:32 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: How to suppress the output? [message #545203 is a reply to message #545199] Mon, 27 February 2012 20:51 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member
I have searched some website. set termout off is useful for that. But it failed.
Re: How to suppress the output? [message #545204 is a reply to message #545203] Mon, 27 February 2012 20:56 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
I do not understand what you expect/desire.
Re: How to suppress the output? [message #545206 is a reply to message #545203] Mon, 27 February 2012 21:03 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member
I want test.log display like this:

id||chr(9)||
owner||chr(9)||
object_name||chr(9)||
subobject_name||chr(9)||
object_id||chr(9)||
data_object_id||chr(9)||
object_type||chr(9)||
created||chr(9)||
last_ddl_time||chr(9)||
timestamp||chr(9)||
status||chr(9)||
temporary||chr(9)||
generated||chr(9)||

[Updated on: Mon, 27 February 2012 21:08]

Report message to a moderator

Re: How to suppress the output? [message #545217 is a reply to message #545193] Mon, 27 February 2012 23:21 Go to previous message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set verify off

Regards
Michel
Previous Topic: not able to debugg in pl sql developer
Next Topic: TOAD says : You have no oracle clients installed
Goto Forum:
  


Current Time: Thu Oct 23 13:49:05 CDT 2014

Total time taken to generate the page: 0.08959 seconds