Re: How to generate a "tab" value in SQL*Plus

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: 2000/09/20
Message-ID: <8qbae0$mcs$1@nnrp1.deja.com>#1/1

Hi.

Try to concatenate CHR(9):

SELECT 'aaaa' || CHR(9) || 'bbbb' FROM DUAL

HTH. Michael

In article <8q8s7s$qn9$1_at_nnrp1.deja.com>, Susie Grace <hlng_at_usa.net> wrote:
> I want to generate a "tab" between columns in SQL*Plus, in order to
> spool a flat file that can be imported into Excel.
>
> What happens frequently is that commas and other keyboard values are
> commonly typed in column values; this can confuse Excel as to what is
> the actual column separator.
>
> I wish to do a Select column1, "tab", column2, "tab", and so forth,
> replacing "tab" with the equivalent of what translates into a tab.
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 20 2000 - 00:00:00 CDT