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 foreign key sql?

943

---

Difference between truncate, delete and drop commands?

1023

---

How do you create a db file?

956

---

Are stored procedures compiled?

871

---

Is postgresql a server?

995

---

What is sql and also describe types of sql statements?

994

---

What is pl sql in dbms?

900

---

Is inner join same as self join?

1060

---

How can you select unique records from a table?

992

---

Why do we use cursors?

919

---

What is a unique key and primary key and foreign key?

918

---

Explain select statements in sql?

999

---

What is the least restrictive isolation level? : Transact sql

996

---

what are the differences among rownum, rank and dense_rank? : Sql dba

981

---

What are dml commands?

939

---