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
- 10183 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
How to convert characters to times in oracle?
How to store pictures on to the database?
What do you understand by database schema and what does it hold?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to assign values to data fields in record variables?
How can windows applications connect to oracle servers?
What is a select query statement in oracle?
How to use attributes of the implicit cursor in oracle?
How to set a transaction to be read only in oracle?
What is the difference between truncate & delete command?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Why is oracle used?
Is postgres faster than oracle?
What is a lookup table in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
