Re: Parent/Child Table Design

On Feb 5, 3:10�pm, Digital Logic <mrodd..._at_hotmail.com> wrote:
> A bit a newbie to Oracle so I apologize if this is a simple question.
> I need to implement two tables similar to the classic order and order
> details example. �I've place a rough description of the two tables
> below. �How would I autogenerated values for the OrderLineNumber
> column given that that should be unique for each order and not for
> each order line. �I experimented with using triggers to generated the
> numbers based on the records already present in the table. �I put
> together a trigger that works as long as you're only insert a single
> row at a time, but does not work for multiple rows. �It would
> appreciated if anyone has a solution.
>
> Orders(
> � OrderID integer primary key,
> � ......
> );
>
> OrderLines(
> � OrderID integer not null,
> � OrderLineNumber integer not null,
> � ....
> � Constraint OrderLines_PK
> � � Primary Key (OrderID, OrderLineID),
> � Constraint OrderLines_FK
> � � Foreign Key (OrderID)
> � � References Orders(OrderID)
> );

Post your trigger code and someone may provide some additional insight.

David Fitzjarrell Received on Tue Feb 05 2008 - 15:17:14 CST