create a function getSoftwares(p_licence_id ) which returns varchar2 string of softwares and then simply run query on licence table
select licence_id , getSoftware(licenceid) from licence ; I hope you know what to write in getSoftwares . -ak ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 4:28 AM > > Hi all, > > i have 2 tables software and licence. 1 licence can have many softwares. > > softwares > ------------ > name platform Licence_id > -------------------------------------------- > abc NT 1 > def WIN2K 1 > ghi all 2 > > i want to write a query that displays the results as follows > > licence_id softwares > ----------- ----------------------- > 1 abc (NT), def(WIN2K) > 2 all > > Any suggestions on how i can do this? > > cheers! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
