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 will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

What are sql constraints?

0 Answers  

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

What is the reports view in oracle sql developer?

0 Answers  

---

Why do we use cursors?

0 Answers  

---

How can I see all tables in sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

Why use truncate instead of delete?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

What is the use of pl/sql table?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---