Interested to Buy Any Domain ? << Click Here >> for more details...
without using count(*) and rownum how can we count total
record in a table
- 5 Answers
- 9909 Views
- AC, HP, I also Faced
- E-Mail Answers
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 backup in Oracle?
How to select some rows from a table in oracle?
Which is better Oracle or MS SQL? Why?
What are the different types of database objects?
What privilege is needed for a user to delete rows from tables in another schema?
How to best split csv strings in oracle 9i?
What would you do with an in-doubt distributed transaction?
Does oracle partitioning improve performance?
Hi Can any one tell me what are the API's used in requisition import.
How to declare a local variable?
What is set operator oracle?
What is columnar storage what is the advantage?
How to drop a stored procedure in oracle?
How to get a create statement for an existing table?
How to bring a tablespace online?
