Home » SQL & PL/SQL » SQL & PL/SQL » Triggers (Oracle 10g)
Triggers [message #404063] Wed, 20 May 2009 04:29 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

can anybody tell me how i can write a triger using cursor .actually i have 2 tables tab1 and tab2 once the record in tab2 is saved or inserted it should pick the values from tab1
Re: Triggers [message #404065 is a reply to message #404063] Wed, 20 May 2009 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Fundamentals
Chapter 9 Coding Triggers

Regards
Michel
Re: Triggers [message #404085 is a reply to message #404065] Wed, 20 May 2009 05:12 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

but do u have any sample triggers with cursor
Re: Triggers [message #404091 is a reply to message #404063] Wed, 20 May 2009 05:26 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
You do realize that coding a cursor in a trigger isn't really any different to coding a cursor in a procedure?
Re: Triggers [message #404097 is a reply to message #404085] Wed, 20 May 2009 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
arif_md2009 wrote on Wed, 20 May 2009 12:12
but do u have any sample triggers with cursor

Maybe you should read the whole book as well as PL/SQL User's Guide and Reference

Regards
Michel

Re: Triggers [message #404106 is a reply to message #404097] Wed, 20 May 2009 07:09 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks
Previous Topic: SQL query
Next Topic: UPDATE with random order
Goto Forum:
  


Current Time: Sun Dec 04 06:49:10 CST 2016

Total time taken to generate the page: 0.17303 seconds