Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help, Help, Help

Re: Help, Help, Help

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 19 Dec 1998 01:38:43 GMT
Message-ID: <3681fe76.8755064@netnews.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US