To: Multiple recipients of list ORACLE-L |
| <[EMAIL PROTECTED]> |
| cc: (bcc: PK Deepa/VGIL) |
| Subject: Re: Database trigger to record user
[EMAIL PROTECTED]@fatcity.com on 10/17/2002 03:13:26 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
I guess, the problem you're having is that, ':new'||v_column is understood
as a string and not a
No inside a trigger :new.Column_name, and :old.column_name gives the before
and after values
regards
naveen
-Original Message-
Sent: Thursday, October 17, 2002 6:19 PM
To: Multiple recipients of list ORACLE-L
Wouldn't you have to use two triggers, one to capture the before image, and
on
Wouldn't you have to use two triggers, one to capture the before image, and
one to capture the after image? Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 4:38 AM
> [EMAIL PROTECTED] wrote:
> >
> > Hi ,
> >
> > We
[EMAIL PROTECTED] wrote:
>
> Hi ,
>
> We want to create a database trigger to maintain the log history of
> transaction tables (Not the Oracle Archive Log).
>
> Our requirement is to create a common Oracle database trigger. Only the
> table name will be different in these
> triggers. The column
Hi ,
We want to create a database trigger to maintain the log history of
transaction tables (Not the Oracle Archive Log).
Our requirement is to create a common Oracle database trigger. Only the
table name will be different in these
triggers. The column names can be taken from "all_tab_columns" v