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

why should required for Indexed by table in pl/sql

3 Answers  

---

What is crud sql?

0 Answers  

---

How can use stored procedures in sql?

0 Answers  

---

Can we use commit inside a trigger?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

What is the usage of the distinct keyword?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

Can we group by two columns in sql?

0 Answers  

---

What does sql stand for?

0 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

is mysql query is case sensitive? : Sql dba

0 Answers  

---