Re: Mutating Table

CAM12784 wrote:
>
> I am working on an application that has a parent and child table. The
> child table has a foreign key to the primary key of the parent table.
>
> The user wants a POST-INSERT trigger on the parent table that will force a
> record to be inserted into the child table whenever a record is created in
> the parent table. The application also does not want to do a commit until
> both rows are created.you need to visit: http://govt.us.oracle.com/govt/owa/style.page?p_id=2&p_sub=3

This has Thomas J. Kyte's famous stored proceedures that automatically create the proper triggers... unless you are a SQL masochist.

There are other goodies there...

Steve Shiflett Received on Mon Aug 19 1996 - 00:00:00 CEST