without using count(*) and rownum how can we count total
record in a table
Answer Posted / vignesh lakshmirajan
simple..!!! Findout the primary key of the table..
then..
select count(primary_key_column) from table;
thats all; becos count vil work with non-null values.
primary key cant b null..
so.. v can use count on primary key...
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is query image?
What is the disadvantage of User defind function?
How to export data with a field delimiter?
Where are the settings stored for each instance in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is Data Dictionary Cache in Oracle?
What privilege is needed for a user to connect to oracle server?
What is PL/SQL ?
What do you know about normalization? Explain in detail?
What is different types of joins?
How to omit columns with default values in insert statement in oracle?
What is an oracle database table?
How to estimate disk space needed for an export job?
Explain drop constraint oracle?
How to enter a new row into a table interactively?