Answer Posted / manmeet singh

schema is like a object of ur database
like
tables,view,procedures,function..

How to initialize variables with default values?

634

---

Why does for update in oracle 8 cause an ora-01002 error?

545

---

Explain an index?

658

---

What is the difference between substr and instr?

519

---

What are nested tables?

673

---

---

How different is ms access and oracle?

547

---

Respected sir, Please send me technical questions related to oracle apps..

1379

---

What is the difference between pre-select and pre-query?

621

---

When system tablespace is created?

605

---

How to check the oracle tns settings?

573

---

What is a snapshot in oracle database?

578

---

Explain oracle 12c new features for developers?

540

---

Explain the use of rows option in exp command.

585

---

How a tablespace is related to data files?

583

---

What is materialized view in Oracle?

630

---