Expertise Requires With Data Extraction

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 26 Oct 2005 03:10:01 -0700
Message-ID: <1130321401.169756.194060@g43g2000cwa.googlegroups.com>

Hi,

I am new to this group. I hope someone could help me on this.

I want to extract a tables data into a delimited file. Currently i am using spool commmand and in that simple select statement to output the data into output file.

Here is my command
SET HEADING OFF
SET FEEDBACK ON
SPOOL outputfile.txt
SELECT RTRIM(COLNAME1)||'|'||RTRIM(COLNAME2)||'|'||.... FROM TABNAME; SPOOL OFF
EXIT I just wanted to know is there any fast way to export the data? Is there any alternative?

any help would be greatly appreciated?

TIA Received on Wed Oct 26 2005 - 05:10:01 CDT