Re: trigger

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Feb 2007 08:11:12 -0800
Message-ID: <1171469472.126594.5680@v33g2000cwv.googlegroups.com>

On Feb 14, 9:36 am, Filipe David Borba Manana <fdman..._at_cern.ch> wrote:
> Hi,
>
> How can I create a trigger whose purpose is to duplicate the data
> inserted in one table to another table?
>
> I want that each time a row is inserted at table A, a row at table B is
> inserted with a column (groupid) that as the same value as the groupid
> field in the row inserted at table A.
>
> Many thanks.

Have you looked at the examples in the SQL manual?

Literally what you need is there.
Online manuals: http://tahiti.oracle.com

HTH -- Mark D Powell -- Received on Wed Feb 14 2007 - 10:11:12 CST