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

Explain an integrity constrains?

700

Is rowid unique in oracle?

530

What are the different oracle database objects?

588

How to sort the query output in oracle?

613

How do you store pictures in a database?

563

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1833

How to end the current transaction in oracle?

560

What is sequence?

624

Difference between oracle's plus (+) notation and ansi join notation?

579

What is oracle analytical function?

529

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

859

What is the usage of control file in oracle?

611

What is partitioned table in Oracle?

639

How many categories of data types?

574

Â What are the oracle DML commands possible through an update strategy?

583