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 can we force the database to use the user specified rollback segment?

1064

What is the difference between Delete, Truncate and Drop in Oracle?

1064

Why we use bulk collect in oracle?

966

How can Oracle users be audited?

1054

What is merge statement used for?

967

What is hot backup and logical backup?

998

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

2682

What are the types of partitions in oracle?

973

what is dynamic SGA and static SGA

4327

Explain the difference between replace() and translate() functions in oracle?

973

How to bring a tablespace online?

993

How to run create database statement again?

1076

What are the differences between blob and clob in oracle?

1028

How do I use os authentication with weblogic jdriver for oracle and connection pools?

996

How translate command is different from replace?

1005