Re: HELP (How to export a table to a delimetered text file)

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

[Quoted] Unfortunately, there isn't an easy way to export the data to delimited file. But you can do this

select col1 || '^' || col2 || '^' || col3 || '^' || col4 from table_name

Spool the output to a file
Open the file using MS-EXCEL, specify '^' as the delimiter. Excel will do the rest for you

Regards

N.Prabhakar

Seigmund Akinwande Johnson wrote:

> Help ,
> Does anyone know how to do this ?

--------------CCDC689BE2498082B231DC8A
Content-Type: text/x-vcard; charset=us-ascii;  name="prabhakar.narayanan.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Prabhakar Narayanan
Content-Disposition: attachment;

begin:vcard
n:Narayanan;Prabhakar
tel;work:65 439 5862
x-mozilla-html:FALSE
org:Credit Lyonnais Securities Singapore Pte Ltd;Technology version:2.1
email;internet:Prabhakar.Narayanan_at_clsasia.com title:Mr.
adr;quoted-printable:;;32nd Floor=0D=0AHitachi Tower;Singapore;;;Singapore end:vcard

--------------CCDC689BE2498082B231DC8A-- Received on Fri May 07 1999 - 09:25:34 CEST