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.

Explain a synonym?

983

---

How to Truncate Table in Oracle

1105

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1636

---

What is the usage of control file in oracle?

1032

---

How to define a variable of a specific record type?

1024

---

How many types of synonyms in Oracle?

1075

---

Explain the function of optimizer in oracle?

1070

---

What is the difference between count (*), count (expression), count (distinct expression)?

968

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4302

---

What the is the diff between local index and global index. give some example.

1594

---

What is execute immediate in oracle?

959

---

Why is oracle so popular?

944

---

How can I get column names from a table in oracle?

997

---

How to loop through a cursor variable?

1028

---

What is a select query statement in oracle?

907

---