Answer Posted / varma

union:
Union combines result set of two select statements
into one result set and from the result it eliminates
duplicate rows.

Minus:
Minus takes the result set of one select statement
and removes those rows that are also returned by another
select statement.

How many subqueries can be nested in a statement?

710

---

What are user defined functions?

782

---

What is an oracle stored procedure?

809

---

What problem one might face while writing log information to a data-base table in pl/sql?

785

---

When is the explicit cursor used ?

781

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

779

---

What is pl/sql table? Why it is used?

764

---

What is crud sql?

738

---

What is the sql*loader? : aql loader

798

---

When you have to use a default "rollback to" savepoint of plvlog?

930

---

What is the syntax to add a record to a table?

806

---

What is pivot in sql?

694

---

what is subquery? : Sql dba

798

---

Are there any features that are decommissioned in 11g that are not present in 11g?

1857

---

is mysql query is case sensitive? : Sql dba

795

---