Answer / guest

Procedure is a stored database object and can be called
when is required. Procedure can have three parameters
IN,INOUT,OUT .IN is default parameter in a Procedure.

Ideally Procedure doesn't return a value but if required
same can be achieve throug OUT Parameter.

Syntex is :
CREATE OR REPLACE PROCEDURE <<Procedure Name>>
(<<PARAMETERLIST DATATYPE>>
IS
BEGIN
<<Code Here>>;
END <<Procedure Name>>;
In procedure arguments datatype size is not required.

Answer / raju.r

It's set of pre-compiled set of SQL statements. no need for
compile the procedure again and again..

Answer / shivashanker

Procedure is named pl/sql block or sub-program used to manipulated the data within the databse.OR It is used to perform some action within the databse

what is a primary key? : Sql dba

0 Answers  

---

What is recursive join in sql?

0 Answers  

---

Which table is left in join?

0 Answers  

---

How to know the last executed procedure?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is left join in sql?

0 Answers  

---

What is spool?

0 Answers  

---

discuss about myisam index statistics collection. : Sql dba

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

---

What is acid property in a database?

0 Answers  

---