Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Delimiter
Set colsep '|'
Jack
-----Original Message-----
From: Roger Xu [mailto:roger_xu_at_dp7uptx.com]
Sent: Tuesday, March 02, 2004 9:26 PM
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: Delimiter
What is the right syntax to do the following?
set delimiter '|';
select * from tablename;
And it outputs:
cola1|colb1|colc1|cold1|
cola2|colb2|colc12cold2|
.. .. ..
colan|colbn|colcn|coldn|
n rows selected
Thanks,
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |