OraFAQ Forum: Server Administration » Export the result of a query to text file

Home » RDBMS Server » Server Administration » Export the result of a query to text file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export the result of a query to text file [message #374073]

Wed, 23 May 2001 20:45

jeanette
Messages: 1
Registered: May 2001

Junior Member

HI;
I need to run SQL (projection and selection type queries) and save the results to a tab (or comma)delimited text file, is there a way to do this other than use spool as my text editor progams don't like opening 40+Mb files just so I can remove the first few lines.

Report message to a moderator

Re: Export the result of a query to text file [message #374074 is a reply to message #374073]

Wed, 23 May 2001 21:37

Sarada
Messages: 27
Registered: April 2001

Junior Member

Hi,

To my knowledge spool is the only way from SQLPLUS to export to text files. You could set the environment like
SET FEEDBACK OFF
SET ECHO OFF
SET PAGES 0
Still, you may need to remove atleast 2 lines from the created flat files. Otherwise you should opt for 3rd party tools like Toad.
Visit www.quest.com - for a free download

HTH

Orashark

Report message to a moderator