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

5 Answers
10389 Views
AC, HP, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to assign query results to variables?

1096

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2386

What happens if the imported table already exists?

1077

if you ctreate table identity

2429

Please explain oracle left join with an example?

1095

What is archive log in Oracle?

1182

How to name query output columns in oracle?

1241

What is the minimum client footprint required to connect c# to an oracle database?

1161

Explain the types of exception?

1194

What do you mean by cdb and pdb in oracle 12c?

1101

What is meant by a deadlock situation?

1154

Explain what are synonyms used for?

1094

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2178

How do I connect to oracle?

1080

How to see free space of each tablespace?

1082