Re: i have a table nad log table
From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 12 Mar 2008 08:25:05 -0700 (PDT)
Message-ID: <5470ad00-0a5f-459f-997c-707c889688f0@b64g2000hsa.googlegroups.com>
Date: Wed, 12 Mar 2008 08:25:05 -0700 (PDT)
Message-ID: <5470ad00-0a5f-459f-997c-707c889688f0@b64g2000hsa.googlegroups.com>
On Mar 12, 2:12 pm, sameer <sameer.dhy..._at_gmail.com> wrote:
> hello friends
> i have a table nad log table
> i want ti write a trigger ,so tht any dml on the table will have
> entry in log table
> like if i insert
> then insert stament in the log table
You need an after insert for each row trigger.
Also please try to type *full* or *complete* words. This might be difficult for someone from your locale, but right now your text reads like the text of a 6 year old.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Mar 12 2008 - 10:25:05 CDT