Answer / rajesh

stored procedure is a named pl/sql block which accept some
parameter and performs some action....and its a one time
compilation....

Answer / 6/8/07

It is named pl/sql block that can accept parameters to
perform an action and is stored in database is called
stored procedure

Answer / charumathi

Store Procedure is named PL-SQL block stored in oracle
server when loaded into memory while execution.
A stored procedure is -a named group of SQL statements
-that have been previously created
and stored in the server database.
-Stored procedures accept input
parameters so that a single procedure can be used over the
network by several clients using different input
data.
-Stored procedures reduce network
traffic and improve performance. Additionally, stored
procedures can be used to help ensure the integrity of the
database.

Answer / rajeev

NAMED PL/SQL BLOCK STORED IN ORCALE SERVER , CAN ACCEPT
PARAMETERS AND CAN BE INVOKED REPEATDLY BY NAME .

Answer / uday

Sp is nothing but Group of T-Sql Statments compiled into a
single execution plan.

Sy: create procedure Pname

{@parameter1 datatype,@parameter2.........)
as

SQL Statments

end

Plz let me know if i am wrong
uday_testing@yahoo.co.in

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What is sql basics?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

---

What is the difference between inner join and outer join?

0 Answers  

---

What is pragma in pl sql?

0 Answers  

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

what is text? : Sql dba

0 Answers  

---

What version is sql?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---