Re: SQL*Plus / Tab Deliminated

Jim Morris (morri055_at_gold.tc.umn.edu) wrote:
: 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

Try:
  select CUST.USER_ID||chr(9)||

  ( 9 is ascii code for tab...)

  i hope it helps.....

  Srini Kunamneni Received on Thu Jul 04 1996 - 00:00:00 CEST