Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30131 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 are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is package in pl sql?
What is query execution plan in sql?
What are different types of statements supported by sql?
Name the operator which is used in the query for pattern matching?
How to fetch alternate records from a table?
Which join is default?
What is the non-clustered index in sql?
How do I turn a list into a table?
Can there be 2 primary keys in a table?
How to start oracle sql developer?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Is primary key an index?
How many scalar data types are supported in pl/sql?
What is multiple columns?
