Answer / 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.

Answer / greatasoft-mani.b

Stored Procedure's are precomplied one. When ever you call
a stored procedure it generate the result faster than
ordinay coding. The improve the performance of the
application i.e to reduce the time stored procedure's are
used

Answer / roopesh kumar

The stored procedures are compiled pl/sql code block that
are stored in oracle's data dictonary as p-code. When we
have to use a perticular code block many times then we
should use procedure, function etc.

The use of procedure save time of execution of a block &
remove the need to write the code of a block every time.

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

---

What is column?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

What are two parts of package ?

2 Answers   Infosys,

---

How can you fetch common records from two tables?

0 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

When do we use triggers?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

How to create your own reports in sql developer?

0 Answers  

---