Select max(rownum) from table

how to find count rows in table without count function?

Question Posted / mani

Answer Posted / mani

Select max(rownum) from table_name;

Is This Answer Correct ?

35 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the ansi data types supported in oracle?

947

What happens if you lost a data file?

1034

How to create an oracle database manually?

1085

Explain an exception?

994

How to see the table columns used in an index?

1024

What are the types of partitions in oracle?

1036

what is reindexing?

1677

What is the difference between alert log file and tarce file ?

2172

How to convert characters to times in oracle?

1023

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344

What are the uses of Database Trigger ?

1720

What do you understand by a database object? Can you list a few of them?

1018

What is query image?

981

What are the numeric comparison operations?

1111

What is the difference between Delete, Truncate and Drop in Oracle?

1131