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

What is foreign key in sql with example?

937

how to drop an existing index in mysql? : Sql dba

1069

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

How many triggers can be applied on a table?

935

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

What do you understand by case manipulation functions?

1034

what are the differences between binary and varbinary? : Sql dba

1044

Show the two pl/sql cursor exceptions.

1199

Are stored procedures faster than dynamic sql?

1040

How to fix oracle error ora-00942: table or view does not exist

1016

What are string functions in sql?

1244

Define SQL and state the differences between SQL and other conventional programming Languages?

1217

Is left join and outer join same?

1070

What is column?

992

Is and as keyword in pl sql?

961