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 is oracle rowcount?

1143

How to create a new table in oracle?

1226

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

2406

Why should I use oracle database?

1040

What is java oracle used for?

1072

What happens to the current transaction if a ddl statement is executed?

1050

Explain what are clusters?

1153

How to convert characters to numbers in oracle?

1109

What is oracle update statement with inner join ?

1109

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2595

Explain joins in oracle?

1088

How to use windows user to connect to the server?

1043

How to use an explicit cursor without open statements?

1097

What is Virtual Private Database in Oracle?

1146

What is an oracle user account?

1034