Re: Select statement question

From: TriTech Microelectronics <tritech_at_technet.sg>
Date: 1995/07/31
Message-ID: <3vi2uf$2p7_at_raffles.technet.sg>#1/1


You can do this with concatenation (||): eg.
select empno||','||ename||','||deptno
from scott.emp;

Regards,

Ngo Lip Wee (lwngo_at_tmi.com.sg)
Tritech Microelectronics International Pte Ltd

Ryan A. Cox (rcox_at_jasmine.psyber.com) wrote:
: I need to pull some data out of an Oracle database with SQL. It would greatly
: simplify my life if, somehow, through the select statement I could insert
: commas and quotes in such a manner that my spool file would be a comma
: delimeted format. If this is possible please let me know.
 

: --
: --- http://www.psyber.com/~rcox
Received on Mon Jul 31 1995 - 00:00:00 CEST

Original text of this message