Programming Help

Web Development



What's Here?

  • Members: 150,240
  • Replies: 507,828
  • Topics: 80,073
  • Snippets: 2,668
  • Tutorials: 707
  • Total Online: 2,331
  • Members: 108
  • Guests: 2,223

Welcome to Dream.In.Code
Become an Expert!

Join 150,240 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,331 people online right now. Registration is fast and FREE... Join Now!




Oracle trigger

 
 Reply to this topicStart new topic

Oracle trigger
Doka
28 Nov, 2007 - 09:48 AM
Post #1

New D.I.C Head
*

Joined: 28 Jun, 2007
Posts: 22


My Contributions
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!
User is offlineProfile CardPM
+Quote Post

beef
RE: Oracle Trigger
29 Nov, 2007 - 12:55 PM
Post #2

D.I.C Head
Group Icon

Joined: 2 Nov, 2006
Posts: 128


My Contributions
QUOTE(Doka @ 28 Nov, 2007 - 11: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!


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.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/9/09 06:23AM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Be Social

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

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month