Answer Posted / prabhudatta barick

Please ignore my first answer...

as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.

to get the exact record please use this

ANALYZE TABLE <table_name> COMPUTE STATISTICS;

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

What is the difference between view and stored procedure?

966

---

What are the ways on commenting in a pl/sql code?

1146

---

what is a constraint? : Sql dba

1186

---

What pl/sql package consists of?

1097

---

What is the best partition size for windows 10?

1013

---

What is sql and db2?

1015

---

Why do we use view in sql?

977

---

What is union and union all keyword in sql?

1057

---

What is rownum in sql?

1052

---

how to return query output in html format? : Sql dba

1081

---

What are the types of dbms?

982

---

How do you modify a table in sql?

1136

---

How many parts of a pl sql block are optional?

1147

---

What is not equal in sql?

1137

---

What are the different types of functions in sql?

1067

---