better way is to use the sys.indexes table where it gives the total no row

how do u know the total no of rows in a table?

Question Posted / gurudatt

Answer Posted / gurudatt

better way is to use the sys.indexes table where it gives the total no rows for each table.

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

1071

Can we call procedure inside function in oracle?

1099

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

How do I escape a reserved word in oracle?

1201

How to connect to a local oracle 10g xe server?

993

How to use "in out" parameter properly?

1051

How to convert characters to dates in oracle?

1103

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

What happens to the current transaction if the session is ended?

1099

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

1062

Why do you use stored procedures and state some of its disadvantages?

1028

How to call a sub procedure?

1099

Can multiple columns be used in group by in oracle?

990

What is a cognitive schema?

973

Explain the use of compress option in exp command.

1021