Answer / anbu

Stored procedures is like a simple PLSQL/instructions
programme which can perform desired operation to get the
exact output from the oracle server(if the DB is oracle).
The user defined stored proceture can be created by users
and they can use funtions,procedure and packages to get the
output from the database engine.
The next thing is they can call it at any part in the
main programme.

Answer / s.aravindhna

Microsoft SQL Server provides the stored procedure
mechanism to simplify the database development process by
grouping Transact-SQL statements into manageable blocks.

Benefits of Stored Procedures

Why should you use stored procedures? Let's take a look at
the key benefits of this technology:
Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
Efficient reuse of code and programming abstraction. Stored
procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
Stored procedures are very similar to user-defined
functions, but there are subtle differences. For more
information, read Comparing Stored Procedures and User-
Defined Functions.

Answer / rishi anand

Stroed procedures are basically set of sql statements.User
defined stored procedures are created by users in which
they can use functions,procedures to get the desired result
from database.

Types of joins?

4 Answers   Microsoft,

---

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,

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is record in pl sql?

0 Answers  

---

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

Why use stored procedures?

0 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

Can we call stored procedure in function?

0 Answers  

---

Do ddl statements need commit?

0 Answers  

---