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.

Which is faster truncate or drop?

1043

---

What is acid property in a database?

1031

---

how to install mysql? : Sql dba

1102

---

Which is faster view or stored procedure?

940

---

Can we call procedure in select statement?

1051

---

What does t sql mean?

942

---

What is query syntax?

961

---

What is $$ in sql?

984

---

What are the types of dbms?

971

---

how to use like conditions? : Sql dba

1105

---

What is the process of debugging?

1064

---

What packages are available to pl/sql developers?

1044

---

Do stored procedures prevent sql injection?

966

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1047

---

Does sqlite need a server?

1042

---