SQL*Plus / Tab Deliminated
From: Jim Morris <morri055_at_gold.tc.umn.edu>
Date: 1996/07/03
Message-ID: <31DA7CA8.4E38_at_gold.tc.umn.edu>#1/1
from customer cust;
Date: 1996/07/03
Message-ID: <31DA7CA8.4E38_at_gold.tc.umn.edu>#1/1
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.
Jim Received on Wed Jul 03 1996 - 00:00:00 CEST