Hi guys.. rownum is virtual column we con't use max(rownum) i t wil

How to count the no of records of a table without using
COUNT function?

Question Posted / suneelkumar

Answer Posted / suneelkumar

Hi guys..

rownum is virtual column we con't use max(rownum) i t will
give the error unknown colum...

so by using cursor we can count

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how many ways to get the current time? : Sql dba

1048

What are the 3 modes of parameter?

1204

Does pl sql work in mysql?

1034

What are the rules to be applied to nulls whilst doing comparisons?

1367

Show code of a cursor for loop.

1110

How do I remove all records from a table?

1116

differentiate between float and double. : Sql dba

1110

What is difference between pl and sql?

1110

What is the order of sql select?

1088

What is data modelling in sql?

1073

what is denormalization. : Sql dba

1160

What is a recursive stored procedure?

1253

Is sql low level language?

1064

what is a table in a database ? : Sql dba

1088

How can a function retun more than one value in oracle with proper example?

1124