Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Converting one record into many
Hi all
I have a table with Receipt lines for Purchase orders with the following structure:
PO_ID NUMBER;
PO_LINE_ID NUMBER;
ITEM_ID NUMBER;
LOC_ID NUMBER;
QUANTITY NUMBER;
In order to print labels for all the items received I need to convert every
record in this table
in as many record indicates.
For instance:
PO_ID PO_LINE_ID ITEM_ID LOC_ID QUANTITY 12 156 9098888 653
I need to have:
ITEM_ID LOC_ID 9098888 65 9098888 65 9098888 65
Of course there is a possibility using a temporary table but I wander if
some of you have a way to to that
without an intermediate table, just SQL code.
Thanks in advance for your help
Cecilio Received on Thu Apr 07 2005 - 17:33:44 CDT
![]() |
![]() |