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
- 9991 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 are the benefits of ordbms?
Differentiate between translate and replace?
How to delete multiple rows from a table in oracle?
Differentiate between pre-select and pre-query?
What is SQL access advisor in Oracle?
How to start instance with a minimal initialization parameter file?
How to rename a tablespace in oracle?
Give the various rollback segment states.
What is oracle sid?
How to create a single index for multiple columns?
What is a read only transaction in oracle?
Explain the characteristics of oracle dba?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
definition of cluster and non-clustered index?
Explain an index segment?
