declare cursor c1 is select * from emp; i c1%rowtype; begin open c1;

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

Question Posted / ajit

11 Answers
29190 Views
TCS, Tesco, I also Faced
E-Mail Answers

Answer Posted / ajit

declare
cursor c1
is
select * from emp;
i c1%rowtype;
begin
open c1;
loop
fetch c1 into i ;
exit when c1%notfound;
end loop;
dbms_output.put_line(c1%rowcount);
close c1;
end;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we connect to postgresql using sql developer?

1048

What is difference between my sql and sql?

1138

what is query cache in mysql? : Sql dba

1080

What is form and report?

1052

What is the use of procedures?

1014

What is %type in sql?

1019

What is sql*plus?

1121

What is difference between sql function and stored procedure?

1063

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1065

What is sql integrity?

1241

how to fetch alternate records from a table? : Sql dba

1165

Can %notfound return null after a fetch?

1101

What are hotfixes and patches?

986

what is a record in a database ? : Sql dba

1104

What does := mean in pl sql?

1090