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 sql optimization

1 Answers   Fidelity,

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

Is id a reserved word in sql?

0 Answers  

---

What does dml mean?

0 Answers  

---

What are the types of optimization?

0 Answers  

---

Which is better varchar or nvarchar?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is varchar example?

0 Answers  

---

What is pl sql and why it is used for?

0 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---

Explain sql data types?

0 Answers  

---

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---