Answer Posted / annu rajput

Data Dictionary contains the informartion about the objects
there are severel data_dictionary in oracle database
for infomation about the tables in database there is a
data dictionary called user_tables
we can get the information about all the tables using the
statement

select * from user_tables;

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

---

What are the different types of failures that occur in Oracle database?

1016

---

how can we store any pdf file in oracle

2096

---

what is the dual table in oracle?

934

---

What are the various types of snapshots ?

972

---

What are the general rules on data consistency?

960

---

What is a subquery?

1059

---

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

2256

---

What are the ways tablespaces can be managed and how do they differ?

2274

---

How to get last row id?

941

---

List the parts of a database trigger.

990

---

What is oracle datasource?

926

---

How do I limit the number of oracle database connections generated by weblogic server?

1008

---

What is columnar storage what is the advantage?

986

---

What are a collation and state the different types of collation sensitivity?

1095

---