| How to suppress the output? [message #545193] |
Mon, 27 February 2012 20:26  |
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 #545206 is a reply to message #545203] |
Mon, 27 February 2012 21:03  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
