SQL statement question ........

[Quoted]     I have a table aaa as follows:

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

[Quoted] [Quoted] 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

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 Sun Jun 13 1999 - 06:27:38 CEST