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

Explain what is table in a database?

0 Answers  

---

What is trigger explain with example?

0 Answers  

---

What is trigger explain it?

0 Answers  

---

Why is sql*loader direct path so fast?

0 Answers  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

What are the different operators available in sql?

0 Answers  

---

What is equi join in sql?

0 Answers  

---

Explain the difference between sql and mysql.

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What is sql and db2?

0 Answers  

---

what are the advantages of cursors than procedures?

2 Answers  

---