what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 27574 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 function and procedure?
What is data manipulation language?
What is the most important ddl statements in sql are?
Can we use ddl statements in stored procedure?
Is id a reserved word in sql?
Does google use sql?
What is self-join and what is the requirement of self-join?
Define tables and fields in a database
What are the two types of exceptions.
what is a join? : Sql dba
how to include character strings in sql statements? : Sql dba
What is cross join sql?
What is cartesian join in sql?
Does mysql support pl sql?
What is keys and its types?
