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.

how to convert character strings to numeric values? : Sql dba

1167

---

How do you modify a column in sql?

1053

---

Is sql a dbms?

1062

---

What are the different tcl commands in sql?

1230

---

What are different methods to trace the pl/sql code?

1171

---

Define overloaded procedure?

1132

---

How can a pl sql block be executed?

1004

---

what are the advantages and disadvantages of views in a database? : Sql dba

1074

---

What is meaning of <> in sql?

1130

---

What is the difference between microsoft access and sql?

1075

---

What is difference between function and trigger?

1111

---

What is a sql statement?

1018

---

What is rename in sql?

1018

---

Is sql a programming?

1027

---

Explain locks? : Transact sql

1055

---