Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need help Reformatting output. Additional comments
It is an on line report. The client will enter the number of IDs, and I
will have to construct a query so the output will be
FROM Id name value
1 a 5
1 b 10
2 a 15
2 b 20
THIS name 1 2
a 5 15
b 10 20
Since I doubt that it is impossible to do it using one query, I probably will need to use a procedure returning me results as one, so it will be displayed on the web-page.
Thank you.
Sergei
-----Original Message-----
Alkaakati
Sent: Thursday, December 12, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L
Hi
Is this in a report if so i can help you else aim sorry.
thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walid Alkaakati
INET: Walid.Alkaakati_at_astrolabeit.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergei
INET: sergei_at_netflip.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). Received on Thu Dec 12 2002 - 12:46:21 CST