rownum is one of the option, can deal with sequence also

With out using count() function. How to the find total
number of rows in a table?

Question Posted / manjunath u

Answer Posted / manjunath u

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I add a database to sql?

1077

What is mutating sql table?

1046

what are the different type of normalization? : Sql dba

980

What is server name sql?

1085

Which join is default?

905

What is the starting oracle error number?

1007

Why is sql*loader direct path so fast?

1063

What is foreign key and example?

894

What is column?

948

How to fetch alternate records from a table?

1172

What is a sql statement?

912

Can there be more than one function with a similar name in a pl/sql block?

933

Which command is used to delete a package?

1107

Which sql most popular?

948

Which table is left in join?

920