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 define a cusotmer as a supplier in ORACLE R12

2232

How to assign a tablespace to a users in oracle?

1050

Explain database link?

1132

How to start an oracle instance?

1027

What are the roles of dba?

1073

What is the difference between $oracle_base and $oracle_home?

1094

How to use null as conditions in oracle?

1091

How do we get field details of a table?

982

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2322

what is the dual table in oracle?

1003

what happened to the global index when I truncate the data in one of the partition?

2027

How to change program global area (pga) in oracle?

1103

What is tns entry?

1164

How to create a new table by selecting rows from another table?

1107

What is the difference between "as" and "is" in an oracle stored procedure?

998