how to spool a Tab seperated file

From: Sebastian Kors <papst_at_gurkenreich.de>
Date: Fri, 02 Nov 2001 13:14:36 GMT
Message-ID: <3be29896.89948959@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 - 07:14:36 CST