without using count(*) and rownum how can we count total
record in a table
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
What are the limitations oracle database 10g xe?
How to connect ms access to oracle servers?
What is the difference between primary key and unique key and foreign key in oracle?
How to empty your oracle recycle bin?
What are the differences between char and nchar in oracle?
Can we create trigger on materialized view in oracle?
How to drop an index?
What are the advantages of oracle 12c?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is primary key indexed by default in oracle?
Does oracle partitioning improve performance?
What is an index associated with a constraint?
What happens to the current transaction if the session is killed?
How to export several tables together?
What is clustered table in Oracle?