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

Explain about functional dependency and its relation with table design?

961

What is oracle sid?

899

What do you mean by redo log file mirroring?

983

Explain the difference between sql and oracle?

1033

How do I manually create a database in oracle?

968

How to write date and time literals in oracle?

957

Explain the use of file option in exp command.

1094

Explain integrity constraint?

1117

How to rename an existing table?

1056

How to create a new table in oracle?

1080

What happens in oracle commit?

974

How to build data dictionary view an new database?

968

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1922

How to use attributes of the implicit cursor in oracle?

959

What is the difference between substr & instr functions?

1133