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

How to grant create session privilege to a user in oracle?

574

How to call a sub procedure?

574

Is oracle a programming language?

572

What do you mean by group by clause?

567

How to filter out duplications in the returning rows using oracle?

646

How would you go about verifying the network name that the local_listener is currently using?

1609

What suggestions do you have to reduce the network traffic?

557

How does oracle handle read consistency?

687

Why oracle is used?

587

what is the difference between functional dependecy and multilevel dependency?

2000

What is a subquery?

620

How to find the duplicate rows count from employees table in oracle?

558

What are set operators?

657

What are the set operators union, union all, minus & intersect meant to do?

570

What is a table index?

571