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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2079

How to synchronize 2 schema's objects?

2121

How to rename an existing table?

1055

How do I escape a reserved word in oracle?

1136

Why do you create or replace procedures rather that drop and recreate.

954

What is an oracle?

960

How to test null values?

1048

Give syntax for SQL and ORACLE joins.

1046

How to see the table columns used in an index?

971

What is the sql query to concatenate column values from multiple rows in oracle?

1002

what is meant by magic query

2139

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1063

What is a nvl function?

966

How do I call oracle stored procedures that take no parameters?

1029

How to drop a stored function?

1089