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

Why does for update in oracle 8 cause an ora-01002 error?

958

What is using clause and give example?

1008

Which is faster join or subquery in oracle?

950

How to create an oracle testing table?

1023

How to define a cusotmer as a supplier in ORACLE R12

2195

Explain an extent?

1062

What are named parameters?

1050

How to define an anonymous block?

1100

What do you understand by database schema and what does it hold?

1198

What is primefaces used for?

1021

Why do we use bulk collect in oracle?

1030

IS it possible to built the oracle database without setting the kernal parameters?

2299

What is the maximum number of triggers that can be applied to a single table?

981

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2278

What is dual table oracle?

942