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

How to run the anonymous block again?

1122

How many categories of data types in oracle?

1023

How do I learn what codesets are available in oracle?

1034

How is it different from a normal table?

1023

How to install oracle odbc drivers?

1084

What are the built-in functions used for sending Parameters to forms ?

3376

What are the roles of dba?

1063

Name the three major set of files on disk that compose a database in Oracle?

1117

What are ddl statements in oracle?

1071

What are the different types of record groups in oracle? Explain each of them

1022

How to apply filtering criteria at group level in oracle?

1034

How to delete a user account in oracle?

961

How does Oracle guarantee data integrity of data changes?

2380

What privilege is needed for a user to query tables in another schema?

966

Explain an index?

1123