Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30070 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
Can a view be mutating? If yes, then how?
What is a file delimiter?
What is percent sign in sql?
What are the benefits of stored procedures?
What is a data definition language?
What are different types of tables in sql?
Why truncate is used in sql?
How do you change a value in sql?
how can we find the number of rows in a table using mysql? : Sql dba
What are the two types of exceptions in pl/sql?
Is sqlexception checked or unchecked?
what are the different index configurations a table can have? : Sql dba
What is the difference between clustered and non-clustered indexes?
How do you write a complex sql query?
What are the different types of triggers?
