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

Try:

SELECT column1 || CHR(9) || column2 || CHR(9) , etc.

HTH

--
S Emmons

Susie Grace <hlng_at_usa.net> wrote in message
news:8q8s7s$qn9$1_at_nnrp1.deja.com...


> 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.