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 a primary key example?

959

---

How do I debug a stored procedure?

1114

---

What are tables and fields in the database?

1112

---

What are the query optimization techniques?

937

---

what is the difference between nested subquery and correlated subquery?

1055

---

How insert into statements in sql?

1075

---

Is it possible for a table to have more than one foreign key?

1030

---

What is the use of index in sql?

1017

---

Can we join more than 2 tables in sql?

1023

---

What are different functions in sql?

947

---

How would you convert date into julian date format?

1006

---

What do you mean by dbms? What are its different types?

1018

---

Explain the advantages and disadvantages of stored procedure?

1150

---

What are user defined functions?

1018

---

Which is better join or inner query?

1049

---