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

Is there any function in oracle similar like group_concat of mysql?

532

Will you be able to store pictures in the database?

630

How to load data from external tables to regular tables?

530

Write a trigger example in oracle?

565

Explain the use of control file?

647

How to use "if" statements on multiple conditions?

713

What is an Oracle index?

1170

How to run create database statement?

567

Describe varray?

579

What is a nested table?

626

State the difference between a primary key and foreign key?

507

How index is implemented in oracle database?

584

what is the scripts in data base?

1596

How to use attributes of the implicit cursor in oracle?

554

Differentiate between translate and replace?

624