without using count(*) and rownum how can we count total
record in a table
- 5 Answers
- 9001 Views
- AC, HP, I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
select count(rowid) from emp;
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
is there a tool to trace queries, like profiler for sql server?
How to assign data of the deleted row to variables?
Difference between hot backup vs. Cold backup?
What does sharding mean?
In the oracle version 9.3.0.5.0, what does each number shows?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is the relation of a user account and a schema?
How to best split csv strings in oracle 9i?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is the difference between a user and a schema in oracle?
Explain the use of indexes option in imp command.
What are the differences between char and nchar in oracle?
master table and child table performances and comparisons in Oracle ?
How many memory layers are in the oracle shared pool?
