Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Converting one record into many

Converting one record into many

From: Cecilio Peral <cecilio_remove_at_tangerine.es>
Date: Fri, 8 Apr 2005 00:33:44 +0200
Message-ID: <d34cfv$2it$1@news.ya.com>


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        65
3

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US