Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nishi
1 security
Stored procedures can help enforce data security. You can restrict the database operations that users can perform by allowing them to access data only through procedures and functions. For example, you can grant users access to a procedure that updates a table, but not grant them access to the table itself. When a user invokes the procedure, the procedure executes with the privileges of the procedure's owner. Because users only have the privilege to execute the procedure and not the privileges to query, update, or delete from the underlying tables, users can invoke the procedure, but they cannot arbitrarily manipulate table
data in any other way.
2 performance
Reduces network traffic as compared to no. of individual SQL sent Since procedure's complied form is available in the database, no compilation step required to execute the code.If procedure is present in SGA then retrieval from disk is not required and execution can begin immediately.
3 Memory allocation
Since stored procedures take advantage of shared memory capabilities of ORACLE, only a single copy of the procedure needs to be loaded into memory for execution by multiple users.
4 productivity
Stored procedures increase development productivity. By designing applications around a common set of procedures, you can avoid redundant coding and increase your productivity.
5 Integrity
By developing all of your applications around a common group of procedures, you can reduce the likelihood of committing coding errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of synonyms?
What is null value in oracle?
What is hash cluster in oracle?
How can you use check constraints for self referential integrity?
What are the differences between number and binary_float in oracle?
How to run queries on external tables?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Who developed oracle & when?
Why is oracle so popular?
What are the uses of synonyms?
What is using clause and give example?
types of indexes and the rationale behind choosing a particular index for a situation.
How to connect the oracle server as sysdba?
What is a server parameter file in oracle?
How to drop an index in oracle?
