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 truncate is used in sql?

0 Answers  

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

What is varchar sql?

0 Answers  

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

why we use nocopy?

2 Answers   Polaris,

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

What is difference between cursor and trigger?

0 Answers  

---

Is left join same as join?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---