Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question
epipko_at_gmail.com wrote:
> Hi all,
>
> create table t_
> (trimester number(1),
> month_id number(2),
> month_name varchar(3));
>
> insert into t_ values (1,1,'JAN');
> insert into t_ values (1,2,'FEB');
> insert into t_ values (1,3,'MAR');
> insert into t_ values (1,4,'APR');
> insert into t_ values (2,5,'MAY');
> insert into t_ values (2,6,'JUN');
> insert into t_ values (2,7,'JUL');
> insert into t_ values (2,8,'AUG');
> insert into t_ values (3,9,'SEP');
> insert into t_ values (3,10,'OCT');
> insert into t_ values (3,11,'NOV');
> insert into t_ values (3,12,'DEC');
>
> commit;
>
> select * from t_ where trimester = 2;
>
> TRIMESTER MONTH_ID MONTH_NAME
> 2 5 MAY
> 2 6 JUN
> 2 7 JUL
> 2 8 AUG
>
>
> Question: how can i list all month for given trimester in one row???
> For instance:
> TRIMESTER MONTH_1 MONTH_2 MONTH_3 MONTH_4
> 2 MAY JUN JUL AUG
>
> Thanks,
> Eugene
www.psoug.org
click on Morgan's Library
click on DECODE.
Daniel Morgan
www.psoug.org
Received on Thu May 04 2006 - 18:14:37 CDT