Answer Posted / nannesaheb chinthalacheruvu

Procedure :
->Procedure is a Named PL/SQL Block which can be stored in
Database in compile form.
->Procedure is used to execute the Perticular task.
->Procedure Does not required RETURN clause.
->Procedure Does not Return value
->It is not posible to execute using SQL statements.
->Procedures can be execute using a)Execute/Call,b)Anonymous
Block

Function :
->Function is a Named PL/SQL Block Which can be Stored in
Database in Compile Form.
->Function is used for Calculation Perpose.
->Fuction Does Contains RETURN Type
->Fuction Can Return only One Value.
->Fuction can Execute using SQL Statements when We can not
Perform any DML Operations in Function.
->Using Out Mode Parameters we can Return Multiple Records
in Function.

what is bdb (berkeleydb)? : Sql dba

778

---

how to create a new view in mysql? : Sql dba

709

---

Differentiate pl/sql and sql?

763

---

What is use of package in pl sql?

740

---

What is constant in pl sql?

732

---

What is the difference between sql and isql*plus?

738

---

What is the difference between partition and index?

688

---

What are the types of variables use in pl sql?

714

---

How many tables can you join in sql?

726

---

Explain cursor types?

769

---

explain the difference between myisam static and myisam dynamic. : Sql dba

724

---

What is the syntax to add a record to a table?

807

---

What is embedded sql in db2?

730

---

how to add a new column to an existing table in mysql? : Sql dba

798

---

what is normalization? : Sql dba

760

---