Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 29761 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / qx1789
he major difference to keep in mind is that trigger code is hard-parsed every time the trigger runs. You should therefore code all of your trigger actions in stored procedures (preferably implemented in packages, per good programming practice), and limit the trigger body to a PL/SQL block that just invokes the procedure. Learn sql from https://www.youtube.com/watch?v=7Vtl2WggqOg
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by stored procedures?
What is a data manipulation language?
How do I remove duplicates in two columns?
What are the types pl/sql code blocks?
What is the trigger in sql?
What are the types of variable use in pl sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is an invalid partition table?
What is the difference between a subquery and a join?
what are properties of a transaction? : Sql dba
Is sqlite thread safe?
Are sql connections encrypted?
What is basic structure of pl sql?
Why query optimization is needed?
What are the most important characteristics of pl/sql?
