Re: SQL Unloading

Re: SQL Unloading

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'MAG' on May 28, 2001 at 14:11:00 EST:

In Reply to: SQL Unloading posted by 'Arman Tanzarian' on May 28, 2001 at 13:40:15 EST:

Oracle doesn't supply any data unload tools, but fear not. Use SQL*Plus to select and format your data and then simply spool it to a flat file:

trimspool on
spool myfile.txt
select col1 || ',' || col2 || ',' || col3
from tab1
where col2 = '123';
spool off

Alternatively you can use the UTL_FILE PL/SQL package to do much the same thing, although this is making the issue more complex than it needs to be.

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Oracle doesn't supply any data unload tools, but fear not. Use SQL*Plus to select and format your data and then simply spool it to a flat file: : : trimspool on : spool myfile.txt : select col1 \|\| ',' \|\| col2 \|\| ',' \|\| col3 : from tab1 : where col2 = '123'; : spool off : Alternatively you can use the UTL_FILE PL/SQL package to do much the same thing, although this is making the issue more complex than it needs to be.