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 SQL Tuning Advisor in Oracle?

862

How to start your 10g xe server?

778

Can the query output be sorted by multiple columns in oracle?

748

What is oracle thin client?

767

Is it possible to split the print reviewer into more than one region ?

2022

Please explain compound trigger in oracle?

801

Explain a synonym?

780

Can group functions be mixed with non-group selection fields?

738

What is transport network substrate (tns) in oracle?

787

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1676

Where are the settings stored for each instance in oracle?

882

Explain oracle insert into command?

845

Please explain oracle left join with an example?

767

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

754

How many categories of data types in oracle?

785