Re: SQL statement question ........

If you are wanting the output for each row to be one concatenated string.

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

The reasaon your statement failed is you where trying to alias a column in the middle of
the concatenation.

Kenny Gump

Jimmy wrote in message <3763333A.3F096431_at_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 Mon Jun 14 1999 - 19:21:22 CEST