Answer Posted / prabhudatta barick

Automatic Optimizer Statistics Collection
By default Oracle 10g automatically gathers optimizer
statistics using a scheduled job called GATHER_STATS_JOB.

As it gathers table statistics automatically
so no need to gather table statistics before
running this query.

SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';

This will give u the total no. of records in a table....

How do I start pl sql?

942

---

what are the types of join and explain each? : Sql dba

1035

---

how can we know the count/number of elements of an array? : Sql dba

1060

---

What is the maximum number of columns in sql table?

1167

---

What is difference between procedure and trigger?

974

---

What is schema in sql?

943

---

How many types of indexes are there in sql?

983

---

What is sqlcommand?

1024

---

Is sqlite thread safe?

1040

---

how to get a list of indexes of an existing table? : Sql dba

955

---

What is program debugging?

1240

---

What are the operators used in select statements?

1054

---

What is mdf ldf and ndf?

993

---

List the various privileges that a user can grant to another user?

1036

---

What is pl sql in dbms?

948

---