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 is a nvl function? How can it be used?
What is the difference between I and G in Oracle?
What types of joins are used in writing subqueries?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to compare dates in oracle sql?
What is Library Cache in Oracle?
What is PL/SQL ?
What are joins, explain all types of joins?
What happens if you set the sga too low in oracle?
How to create a new oracle data file?
What is data block in Oracle?
What are the different editions of oracle?
what is the difference between data migration and production migration.
what are steps for interface? where is exchange rate defined in which table?
