RE: sql

Here's a non-elegant, brute force approach

set serveroutput on
declare

   v_text varchar2(4000) := NULL;
   cursor c1 is select * from crap order by id, des;

• assign a value to v_doink that crap.id will never assume. v_doink crap.id%type := 0; begin dbms_output.enable(10000); for x in c1 loop
  • compare equality to whatever you used for initial value. if v_doink = 0 then v_doink := x.id; end if; if v_doink <> x.id then dbms_output.put_line(v_doink||v_text); v_doink := x.id; v_text := NULL; end if; if v_doink = x.id then v_text := v_text||' '||x.des; end if; end loop;
• print the last line. dbms_output.put_line(v_doink||v_text); end; /

Output looks like

1 test1_1 test1_2 test1_3
2 test2_1 test2_2 test2_3
3 test3_1 test3_2 test3_3
4 test4_1 test4_2 test4_3

> -----Original Message-----
> i have this query and result set:
>
> select id, description from x where id = 1
>
> id Description
> 1 test1
> 1 test2
> 1 test3
>
> Is there a way i can retrive the above in this format:
>
> id Description
>
> 1 test1 test2 test3
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).