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

Home -> Community -> Usenet -> c.d.o.misc -> Keep track of history

Keep track of history

From: Cyril Zekser <cyril.zekser_at_cashware.fr>
Date: Thu, 27 Jan 2000 14:20:18 +0100
Message-ID: <38904612.E980CC6@cashware.fr>


Hi,

I have products which can be bundled into larger or smaller parts. I create a table to store these product with one row for each group.

When I explode a bundle, I want to add new rows representing the new shipment, but each row have to remember the origin group.

How can I retrieve all parents for one given group ?

I tried to do so whic a table like this : MyTable( #ID, Qty, Origin ), with Origin pointing to an existing ID in the table, but It doesn't seem to work...

What is the good way to do so ?

Could anybody help me ? Received on Thu Jan 27 2000 - 07:20:18 CST

Original text of this message

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