Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Keep track of history
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