Answer Posted / pravin

sequence is sharable object in database which is use to
generate unique number
use of sequence is like
insert into table(emp_id,name)values
(sequencname.nextvalue,name)
&
cache is the memory use to how manu values preallocates in
memory & keep in memory defined in cache.
by default 20 values can be stored in cache.

How to connect to oracle using service name instead of sid?

1026

---

How to call a sub procedure?

1098

---

How to put more than 1000 values into an oracle in clause?

1031

---

Explain the use of owner option in exp command.

1048

---

Can we call procedure inside function in oracle?

1098

---

What are privileges and grants?

1067

---

How to select some columns from a table in oracle?

1097

---

How to sort output in descending order in oracle?

1047

---

Is primary key indexed by default in oracle?

987

---

what are the default admin accounts in Oracle 10g ?

969

---

What are the uses of synonyms?

1138

---

What is the difference between Delete, Truncate and Drop in Oracle?

1131

---

What is a relational database management system?

1120

---

How to connect the oracle server as sysdba?

1078

---

What is a proxy object?

1067

---