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
- 10156 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
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Give the various exception types.
What is an external table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to create lov dynamically at runtime & attach to text field?
Why does for update in oracle 8 cause an ora-01002 error?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Give the various rollback segment states.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is oracle update statement with inner join ?
How to open and close an explicit cursor in oracle?
State some uses of redo log files?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to define a record variable to store a table row?
