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
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