Start a new topic
Add Reply
Can I use substitution varaible inside a trigger in oracle, when creating a trigger on inserting or updating on a table, can I use whatever I want... like when I am creating function or a procedure?
Thanks!
Oracle trigger
Page 1 of 1
Oracle trigger
Rate Topic:
MultiQuote
#2
beef
- D.I.C Head
-
Reputation: 0
- Posts: 128
- Joined: 02-November 06
Dream Kudos: 0
Re: Oracle trigger
Posted 29 November 2007 - 12:55 PM
Doka, on 28 Nov, 2007 - 11:48 AM, said:
Can I use substitution varaible inside a trigger in oracle, when creating a trigger on inserting or updating on a table, can I use whatever I want... like when I am creating function or a procedure?
Thanks!
Thanks!
Do you mean in the trigger itself or in the code to create the trigger? I don't think you could in the trigger itself because you wouldn't have any way to give it the value to substitute.
You can use :new to use get values from the row that's being inserted.
Was This Post Helpful?
0
Page 1 of 1
| 
