Re: PL/SQL
From: (wrong string) ås <odd.morten.sveas_at_accenture.com>
Date: 18 Jan 2003 13:35:25 -0800
Message-ID: <4306a83.0301181335.2c66f6c8_at_posting.google.com>
Date: 18 Jan 2003 13:35:25 -0800
Message-ID: <4306a83.0301181335.2c66f6c8_at_posting.google.com>
I think this would be hard to to in ordinary SQL. You have to make an PL/SQL procedure to help you.
Make a cursor that holds all id1 ond id2 in the table orderd by id1 ( and if you want by id2 )
Loop through the cursor. Make logic that handles comma only between id2s. Print a new line each time the id1 changes.
Regards
Odd M
Received on Sat Jan 18 2003 - 22:35:25 CET