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

Can you have more than one trigger on a table?

0 Answers  

---

What is meant by truncate in sql?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

What are schema-level triggers?

0 Answers  

---

---

What are different types of tables in sql?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

State some properties of relational databases?

0 Answers  

---

Is sql harder than python?

0 Answers  

---

Define sql delete statement.

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---