Re: SQL*Plus / Tab Deliminated

From: Tan La <TLa_at_mtl.marconi.ca>
Date: 1996/07/03
Message-ID: <4repvl$16j_at_gateway.marconi.ca>#1/1


In article <31DA7CA8.4E38_at_gold.tc.umn.edu>, morri055_at_gold.tc.umn.edu says...
>
>I am using SQL*PLUS to create a flat file. This file will be read by
 another
>software application and the data in the flat file must be in a Tab
>deliminated format. Currently, I am using Tilde delimination in the
>following query:
>
>select CUST.USER_ID||'~'||
> CUST.NAME||'~'||
> CUST.ADDRESS||'~'
>from customer cust;
>
>Instead of Tildes, how do I specify the Tab character in my SQL*Plus query?
>
>Any help would be appreciated.
>
>Regards
>
>Jim

The following select statement will help:     

   select CUST.USER_ID||CHR(9)||
          CUST.NAME   ||CHR(9)||
          CUST.ADDRESS||CHR(9) 

   from customer cust;

Tan. Received on Wed Jul 03 1996 - 00:00:00 CEST

Original text of this message