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

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

How to rename a table?

0 Answers  

---

What is pragma in pl sql?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

What is sql keyword?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

what is a record in a database ? : Sql dba

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

What is a boolean in sql?

0 Answers  

---