Re: SQL*Plus / Tab Deliminated
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/07/03
Message-ID: <4rempd$a8h_at_client3.news.psi.net>#1/1
Date: 1996/07/03
Message-ID: <4rempd$a8h_at_client3.news.psi.net>#1/1
In article <31DA7CA8.4E38_at_gold.tc.umn.edu>,
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
>[delimited] format.
select 'a' || chr(9) || 'b' from dual;
chr(9) yields ascii tab. you're welcome.
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Wed Jul 03 1996 - 00:00:00 CEST