Re: how to spool a Tab seperated file

"Sebastian Kors" <papst_at_gurkenreich.de> wrote in message news:3be29896.89948959_at_News.CIS.DFN.DE...
> Hello,
>
> my name is Sebastian Kors from Germany and i have a question.
> I hope to find the asnwer in this newsgroup.
>
> i'm spooling a select statement into an seperate file.
> How can i get tab seperated cols?
>
> getting it comma separeted is no problem, but i need tabs.
>
> here is my script, running on an oracle 8i - SQL*Plus
>
> [script]
> set heading off
> set linesize 300
> set pagesize 150
>
> spool d:\dbshare_demo\material\doc\47\347.lay
>
> select '<ArticleText><Text>' from dual;
> /
>
> select iddoc||','||spid||','||name from db_zuege
> ^-- this must be a tabulator
> /
> select '</Text></ArticleText>' from dual;
> /
> spool off
>
> set heading on
> [/script]
>
> Thanks in advance,
>
> Sebastian Kors
> --
> Die zehn Gebote Gottes enthalten 279 Wörter, die amerikanische
> Unabhängigkeitserklärung 300 Wörter, die Verordnung der europäischen
> Gemeinschaft über den Import von Karamelbonbons aber exakt 25911 Wörter.

Replace the ',' by chr(8) or better still use set colsep chr(8) and you won't need the concatenation construct.

How about the EU banana regulations? I remember there was a quarrel about that several years ago.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address