Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: "SQL*UNloader"
Personally I would use ODBC.
But you can always try someting like this:
set .....
set ....(pagesize, headings, feedback , echo)
select column1||';'||column_n from table;
spool final.file
/
spool off
J. Meirim
>
>I would like to produce a set of files each containing a comma-separated
>list of all the fileds/data of tables pertaining to a schema.
Received on Thu Oct 22 1998 - 19:25:08 CDT
![]() |
![]() |