Answer Posted / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1851

---

Explain a synonym?

608

---

Design database draw er diagram for a certain scenario ?

4105

---

Explain the use of control file?

658

---

How to see the table columns used in an index?

598

---

---

What is max rowid in oracle?

561

---

What is the difference between substr and instr?

523

---

What is a nvl function?

566

---

What are named parameters?

617

---

How to convert csv to table in oracle?

528

---

How to establish administrator authentication to the server?

562

---

What is a trace file and how is it created in oracle?

554

---

How to get a list of all background sessions in the database?

542

---

What is instant client oracle?

546

---

How do I reset a sequence in oracle?

600

---