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


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 Received on Wed Jul 03 1996 - 00:00:00 CEST

Original text of this message