Answer Posted / pankaj mehra

Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function

Differentiate pl/sql and sql?

565

---

Which is faster view or stored procedure?

505

---

What is denormalization in a database?

593

---

What is database migration?

519

---

What is the maximum number of columns in sql table?

551

---

---

How you improve the performance of sql*loader? : aql loader

580

---

Show the cursor attributes of pl/sql.

613

---

How to convert comma separated string to array in pl/sql?

602

---

What is range partitioning?

522

---

what are the different index configurations a table can have? : Sql dba

575

---

how to drop an existing index in mysql? : Sql dba

541

---

How do you truncate?

507

---

how to analyze tables with 'mysqlcheck'? : Sql dba

547

---

what is data integrity? : Sql dba

596

---

what are all the different types of indexes? : Sql dba

532

---