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
10116 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

Write a trigger example in oracle?

1044

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2329

What are the different types of partitions in oracle?

964

Point out the difference between user tables and data dictionary?

976

In the oracle version 9.3.0.5.0, what does each number shows?

1289

How to add a new column to an existing table with a default value?

1011

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3043

how do u setup a replication site?

1972

How can windows applications connect to oracle servers?

1046

List out the components of logical database structure of oracle database.

1023

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2458

What is integrity and what is constraint??Explain with example

2272

What is the difference between pre-select and pre-query?

1207

How to use values from other tables in update statements using oracle?

1072

Can you assign multiple query result rows to a variable?

980