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.

Why indexing is needed?

776

---

How can you know that statistics should be updated?

840

---

Is null operator in sql?

821

---

What is an exception in PL/SQL? What are the two types of exceptions?

896

---

Is coalesce faster than isnull?

733

---

What is foreign key and example?

739

---

What does plv msg allows you to do?

891

---

how is myisam table stored? : Sql dba

819

---

How many types of primary keys are there?

760

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

805

---

How do I truncate a word?

749

---

What are the types of triggers in sql?

756

---

What is a left join?

730

---

What is sql profiling in oracle?

768

---

What is trigger in sql? Explain

742

---