School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!
You're Browsing As A Guest! Register Now...
Become an Expert!

Join 353,887 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 3,175 people online right now.Registration is fast and FREE... Join Now!



Oracle trigger

Oracle trigger Rate Topic: -----

#1 Doka  Icon User is offline

  • New D.I.C Head
  • Pip

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 28-June 07


Dream Kudos: 0

Posted 28 November 2007 - 09:48 AM

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!
Was This Post Helpful? 0
  • +
  • -


#2 beef  Icon User is offline

  • D.I.C Head
  • Icon

Reputation: 0
  • View blog
  • Posts: 128
  • Joined: 02-November 06


Dream Kudos: 0

Re: Oracle trigger

Posted 29 November 2007 - 12:55 PM

View PostDoka, 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!


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
  • +
  • -



Fast Reply

  

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month