Answer Posted / 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.

What is the difference between inner join and left join?

937

---

Does oracle use sql?

878

---

What is a behavioral trigger?

930

---

What is sql prepared statement?

937

---

Inline the values in PL/SQL, what does it mean.?

1156

---

How do you take the union of two tables in sql?

933

---

what is 'trigger' in sql? : Sql dba

1012

---

Is merge a dml statement?

922

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

944

---

What are different sql data types?

954

---

How many types of functions are there in sql?

897

---

Why is theta join required?

1080

---

Why commit is not used in triggers?

992

---

How do you optimize a stored procedure in sql?

893

---

What is difference between hql and sql?

991

---