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 the usage of the distinct keyword?

894

---

What is the difference between inner join and natural join?

708

---

What is sql keyword?

755

---

Which is better stored procedure or query?

721

---

Can I call a procedure inside a function?

738

---

---

What is nvl?

790

---

What is clustered and nonclustered index in sql?

700

---

What are database links used for?

754

---

how can we know the count/number of elements of an array? : Sql dba

772

---

How do you rank data in sql?

680

---

What is embedded sql in db2?

708

---

What is sharding in sql?

738

---

How do I partition a table in sql?

734

---

What is asqueryable?

712

---

Explain alias in sql?

770

---