Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export Data as Text ?
Here is a small script i use, with some slight modification it could be called via a batch process
set head off
set pages 0
set verify off
set serveroutput on
set feedback off
SELECT '&&TAB' FROM DUAL; spool dumpfile.sql
select
decode(c.column_id,1,'Select ',null),
c.column_name,
decode(c.column_id,p.maxc,'from &&tab ;','||'',''||')
from
user_tab_columns c,
(select count(*) maxc
from user_tab_columns where table_name=upper('&&tab')) pwhere
table_name=upper('&&tab')
order by
c.column_id
/
spool off
set head on
SET TERM OFF
set LINES 30000
SET TRIMSPOOL ON
SPOOL &&TAB..TXT
declare
headings1 varchar2(400);
cursor c1 is
select column_name from user_tab_columns where table_name = upper('&&TAB') order by column_id;
for rec in c1
loop
headings1 := headings1 || rec.column_name || ',' ;
end loop;
headings1 := substr(headings1,1,length(headings1)-1);
dbms_output.put_line(headings1);
end;
/
@dumpfile.sql
SPOOL OFF
SET TERM ON
undef tab
set verify on
HTH Conan Received on Wed Aug 09 2000 - 00:00:00 CDT