what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 28101 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 is user defined functions?
What is pessimistic concurrency control? : Transact sql
What's the procedure?
What is a primary key example?
Explain the difference between sql and mysql.
How do I make sql search faster?
what is cross join? : Sql dba
What is a native sql query?
What does bitemporal mean?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How many sql are there?
Define union, minus, union all, intersect ?
Why is pl sql needed?
What is loop in pl sql?
What is the difference between inner join and natural join?
