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 pl sql commands?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

what are the t string functions available in tsql? : Transact sql

0 Answers  

---

What does data normalization mean?

0 Answers  

---

can i give user defined exception in a package

2 Answers  

---

---

What is exception? What are the types of exceptions?

0 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

What is a join?

0 Answers  

---

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

4 Answers   Oracle, TCS,

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Where is sql database stored?

0 Answers  

---

What is sql partition function?

0 Answers  

---