Hi,
I tried this cuz of my curiosity but I got this output with out tab
7369chr(8)SMITH chr(8)CLERK chr(8)
7902chr(8)17-DEC-80chr(8) 800chr(8) chr(8) 20
7499chr(8)ALLEN chr(8)SALESMAN chr(8)
7698chr(8)20-FEB-81chr(8) 1600chr(8) 300chr(8) 30
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:tu5m1ooqcchm2f_at_corp.supernews.com...
>
> "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
>
>
>
Received on Fri Nov 09 2001 - 21:30:27 CST
