RE: Delimiter
- From: Jack van Zanen <JACK@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Mar 2004 21:34:14 +0100
Set colsep '|'
Jack
-----Original Message-----
From: Roger Xu [mailto:roger_xu@xxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 9:26 PM
To: Oracle-L@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
************************************************************************
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by
persons or entities other than the addressee is prohibited. If you have
received this e-mail in error, please contact the sender immediately and
delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: