Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30426 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 do I remove all records from a table?
What is rank () in sql?
What is string data type in sql?
How do you update f as m and m as f from the below table testtable?
what are integrity rules?
What is an emotional trigger?
How do you copy a table in sql?
What is nvl?
What is sql lookup?
In a distributed database system, can we execute two queries simultaneously?
Which join is like inner join?
What are the two types of exceptions.
what is a database transaction? : Sql dba
What is the difference between alter trigger and drop trigger statements?
How to change the order of columns in Oracle SQL Plus ?
