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.

List and explain the different types of join clauses supported in ansi-standard sql?

1356

---

What is parameter substitution in sql?

1029

---

Explain select statements in sql?

1057

---

What is server name sql?

1144

---

How do you optimize a query?

999

---

Can we insert data in view?

963

---

What is sqlerrd?

968

---

What does a pl/sql package consist of?

976

---

How would you convert date into julian date format?

1004

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1107

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1068

---

What are the different ddl commands in sql?

1169

---

Can we write ddl statements in functions?

1116

---

Where is pl sql used?

953

---

Why is the cursor important?

1043

---