SQL statement question ........

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Sat, 12 Jun 1999 21:27:38 -0700
Message-ID: <3763333A.3F096431@comp.polyu.edu.hk>

Hello all,

    I have a table aaa as follows:

create table T_aa (
aaa date,
bbb varchar2(10),
ccc number);

And I want to get the following result with SQL select statement:

a_date, bbb, ccc
01-Jan-1999,50,1
02-Jan-1999,,1
03-Jan-1999,70,2

(column aaa renamed to a_date)

And I write the following SQL statement:

select to_char(aaa, 'DD-MON-YYYY') a_date || ',' || bbb || ',' ||ccc from T_aa;

however, the above statement is invalid. Is is possible to get the result that I want by using a single SQL statement?

Thanks,
Jimmy Received on Sat Jun 12 1999 - 23:27:38 CDT