Answer Posted / hitesh thakur

1)sql is language used to interact with database
WHILE oracle is database system/platform uses sql to
interact with it's object

What is the data pump import utility?

588

---

How to rename an index?

590

---

Can we use bind variables in oracle stored procedure?

492

---

Explain the blob datatype?

622

---

What are the differences between interval year to month and interval day to second?

554

---

---

How to use "in out" parameter properly?

621

---

how may join possible between (requisition with purchase order)

1703

---

How remove data files before opening a database?

566

---

What are joins, explain all types of joins?

1724

---

How to view all columns in an existing table?

552

---

How does the on-delete-cascade statement work?

612

---

How to create a temporary table in oracle?

694

---

What is the best way to do multi-row insert in oracle?

567

---

What is a procedure in oracle?

618

---

Give the various exception types.

552

---