SQL> SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE

without using count(*) and rownum how can we count total
record in a table

Question Posted / rajesh

Answer Posted / rajesh

SQL> SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';

TABLE_NAME NUM_ROWS
------------------------------ ----------
EMP 14

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is columnar storage what is the advantage?

1064

What is pragma autonomous transaction in oracle?

1070

What are the oracle built-in data types?

1074

Can you drop an index associated with a unique or primary key constraint?

1019

How many types of tables supported by oracle?

1077

Give the constructs of a package, function or a procedure.

1045

What is partitioned table in Oracle?

1190

What are operators in oracle?

1055

What is truncate oracle?

971

How to insert a new row into a table in oracle?

1165

why dont we assign not null constraint as table level constraint.

2739

What is the usage of control file in oracle?

1090

How to display employee records who gets more salary than the average salary in the department?

1066

ABOUT IDENTITY?

2060

How to drop an index?

959