Interested to Buy Any Domain ? << Click Here >> for more details...
What are advantages fo Stored Procedures?
- 1 Answers
- 3160 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are main difference between Stored Procedure and Functions.
what r tyhe major differences between oracle 9i & 10g?
What are ddl statements in oracle?
select * from emp what happened internally when we write this query in the sql prompt?
What is meant by recursive hints in oracle?
What is a Public Synonyms ?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the various constraints used in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Does oracle partitioning improve performance?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Oracle General 
