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 sql and explain its components?

592

---

What types of commands can be executed in sql*plus?

542

---

What is the difference between in and between in sql?

573

---

What is the difference between left outer join and left join?

511

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

664

---

---

What does select * from mean in sql?

1983

---

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

546

---

How does postgresql compare to mysql?

573

---

Is sql a backend?

544

---

What is a string data type in sql?

512

---

What is rank () in sql?

529

---

What is data manipulation language?

693

---

What is primary key secondary key alternate key candidate key?

538

---

What are some emotional triggers?

566

---

Which command is used to delete a package?

575

---