what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 28601 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
How many unique keys can a table have?
How many tables can a sql database have?
What are the types of keys?
What are pl/sql cursors?
Are stored procedures faster than queries?
Explain two easy sql optimizations.
Is sql dba a good career? : SQL DBA
What is nosql vs sql?
What is consistency?
define sql insert statement ? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How do you modify a column in sql?
How to convert comma separated string to array in pl/sql?
How to look at the current sql*plus system settings?
how can we optimize or increase the speed of a mysql select query? : Sql dba
