Re: SQL*Plus / Tab Deliminated
From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/07/03
Message-ID: <4rf19s$fgc_at_zimmer.CSUFresno.EDU>#1/1
Date: 1996/07/03
Message-ID: <4rf19s$fgc_at_zimmer.CSUFresno.EDU>#1/1
In article <31DA7CA8.4E38_at_gold.tc.umn.edu>,
Jim Morris <morri055_at_gold.tc.umn.edu> wrote:
<snip>
>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?
Use Chr(9) for the TAB character:
select CUST.USER_ID||chr(9)||CUST.NAME||chr(9)||CUST.ADDRESS||chr(9)
from customer cust;
Regards,
Steve Cosner
Received on Wed Jul 03 1996 - 00:00:00 CEST