Select max(rownum) From dual

without using count(*) and rownum how can we count total
record in a table

Question Posted / sanrai

Answer Posted / sanrai

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220

How to do paging with oracle?

950

How can you merge two tables in oracle?

938

How to use "if" statements on multiple conditions?

1113

Give the various rollback segment states.

1000

How do I limit the number of oracle database connections generated by weblogic server?

1007

What is an oracle database table?

962

Why we use bulk collect in oracle?

972

What is difference between cartesian join and cross join?

1018

Is truncate autocommit in oracle?

1025

How to list all indexes in your schema?

1033

What is procedure overloading in oracle?

994

What is a user role in oracle?

1067

How to check the server version in oracle?

1035

What is ASM (Automatic Storage Management) in Oracle?

1124