Home » SQL & PL/SQL » SQL & PL/SQL » procedure is advantageous than trigger ? Urgent
icon4.gif  procedure is advantageous than trigger ? Urgent [message #205460] Sat, 25 November 2006 00:40 Go to next message
jatinmodh
Messages: 1
Registered: November 2006
Location: Ahmedabad
Junior Member
plz solve my question.

Give two practical examples with justification where the usage of stored procedure will be advantageous as compared to the usage of triggers, where all the same constraints are to be implemented on the same object.
(university question)
Re: procedure is advantageous than trigger ? Urgent [message #205510 is a reply to message #205460] Sat, 25 November 2006 06:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:

plz solve my following question.
Give two practical examples with justification where the usage of stored procedure will be advantageous as compared to the usage of triggers, where all the same constraints are to be implemented on the same object.

Private Messaging will not bring faster response.
In fact will never bring any useful response.

[Updated on: Sat, 25 November 2006 06:04]

Report message to a moderator

Re: procedure is advantageous than trigger ? Urgent [message #205513 is a reply to message #205460] Sat, 25 November 2006 06:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post what effort you have thrown in solving your 'question'.
There are numerous souls around here willing to help you if you can take part in the effort.

[Updated on: Sat, 25 November 2006 06:10]

Report message to a moderator

Re: procedure is advantageous than trigger ? Urgent [message #205564 is a reply to message #205460] Sun, 26 November 2006 02:46 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
And do NOT pm people for the answer. This is a public forum, messages are posted and answered through the forum, not through PMs
[Edit: hm, Mahesh mentioned this already... See how annoying this PM-ing is?]


This is a homework assignment. Why do you think you have to do this, because your teacher is curious for your answer or because he he hopes you _learn_ something from it other than how to post messages to boards?

[Updated on: Sun, 26 November 2006 02:47]

Report message to a moderator

Previous Topic: Function&Procedure
Next Topic: Load/insert image/picture files into oracle 7.0.3
Goto Forum:
  


Current Time: Sat Dec 10 18:40:24 CST 2016

Total time taken to generate the page: 0.07790 seconds