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 are joins in sql?

1028

---

tell us something about heap tables. : Sql dba

1077

---

How can we link a sql database to an existing android app?

1014

---

Is foreign key mandatory?

988

---

What is meant by temporal data?

945

---

What is implicit cursor in pl sql?

1072

---

what is recursive stored procedure? : Sql dba

971

---

what is the difference between primary key and unique key? : Sql dba

1015

---

what are myisam tables? : Sql dba

1016

---

Explain what is table in a database?

1046

---

What are the different types of triggers?

1116

---

How many databases can sql express handle?

968

---

What is the requirement of self-join?

1100

---

What does pragma mean?

1035

---

Which one is faster ienumerable or iqueryable?

917

---