Suppose i have a trigger in which it's updating some value.
Is it possible to call that updated value in a trigger using a select statement
[b]Question asked by visitor preethi[/b]
Printable View
Suppose i have a trigger in which it's updating some value.
Is it possible to call that updated value in a trigger using a select statement
[b]Question asked by visitor preethi[/b]
I am not sure what you are talking about.
If you are talking about update DML trigger, then you can get the old and new variables using :old and :new bind variables.
Hi preethi,
how can a trigger updates value?
Update Trigger get automatically fired when update command is executed and it will roll back all the changes.
Please post your code for reference. It is not at all clear what exactly u want to do through the trigger.