Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help, Help, Help
On Wed, 16 Dec 1998 21:59:48 -0500, "aziz basharyar"
<azizb_at_sprint.ca> wrote:
>How can I create exportable to Excel File ("Tab Delimited Format")
>from Oracle database using PL/SQL.
Use SQL*Plus. Spool your output to a file, and issue a select command like that shown below:
spool c:\export.tab select id || chr(9) || name || chr(9) || address from your_table where id < 1000; spool off
You can use the same technique to get comma-delimited files.
regards,
Jonathan Received on Fri Dec 18 1998 - 19:38:43 CST