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 are sql commands classified?

1090

Should I use mbr or gpt?

1026

What is a table partition?

1134

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1070

Can pl sql procedure have a return statement?

1031

What type of join is sql join?

983

What are the different schemas objects that can be created using pl/sql?

1029

What is sql lookup?

920

Is primary key a clustered index?

968

what is blob? : Sql dba

1149

What does 0 mean in sql?

967

How to assign sql query results to pl sql variables?

1082

What is a subquery in sql?

1041

What are sql objects?

1081

What is a procedure in pl sql?

1212