Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / p.rajasekar
Procedures provide advantages in the following
areas:
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 compliation 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 ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of pl/sql packages?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How do you update a table in sql?
Explain foreign key in sql?
Is truncate ddl or dml?
What are the features of pl sql?
What is cross join example?
what are date and time intervals? : Sql dba
How to fix oracle error ora-00942: table or view does not exist
What is an ndf file?
How are functions and procedures called in PL/SQL?
What are functions in sql?
What is the difference between sql and isql*plus?
what is the difference between $message and $$message? : Sql dba
What is the use of prepared statement?
