Re: Help, Help, Help

From: Victor Shanahan <victor.shanahan_at_capgemini.ie>
Date: Thu, 17 Dec 1998 14:47:41 -0000
Message-ID: <75b5it$97o$1@hagen.cloud9.co.uk>

Hi Aziz,

Try concatenating your columns with CHR(9), the TAB character, before spooling to get a Tab delimited file. Don't forget to SET TRIMSPOOL ON.

EG;     SELECT Col1 || CHR(9) || Col2 || CHR(9) || etc......
            FROM Table

aziz basharyar wrote in message ...
>Hi,
>
>How can I create exportable to Excel File ("Tab Delimited Format")
>from Oracle database using PL/SQL.
>
>Thanks
>
>Aziz
>AzizB_at_cpas.com
>AzizB_at_sprint.ca
>
>
>
Received on Thu Dec 17 1998 - 08:47:41 CST