Have you tried "chr(9)" in place of "','"?
"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.
Received on Fri Nov 02 2001 - 11:10:24 CST
