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
28721 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

explain the delete statements in sql

1038

How can we implement rollback or commit statement in a trigger?

1025

Can a key be both primary and foreign?

986

What does := mean in pl sql?

1038

What are synonyms in sql?

965

What is a procedure in pl sql?

1206

How do I run sql profiler?

1059

Write a query to find the names of users that begin with "um" in sql?

985

What is materialized view in sql?

915

What is a unique constraint?

1065

what is a composite key ? : Sql dba

1043

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037

What is a sql profiler?

1013

how is myisam table stored? : Sql dba

1048

What pl/sql package consists of?

1074