How to count the no of records of a table without using
COUNT function?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / senthil kumar
Hi Ramaprasad 'select max(rownum) from emp; ' this is passible
but
declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;
this is NOT Passible , because this one just show all records Not count it.......
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vikram
select col1,col2,1 as SNO,sum(sno) from emp
group by 1,2,3
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / ramaprasad
select rownum from emp;
select max(rownum) from emp;
declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / kart
using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset
then use the plsql with cursor;
select rownum from table; the last value
is the number of records
Is This Answer Correct ? | 4 Yes | 9 No |
What is a database trigger ? Name some usages of database trigger ?
What is the usage of the distinct keyword?
How do I run a sql script?
How to get each name only once from an employee table?
How to use distinct and count in sql query? Explain
diff b/w function and procedure?
What is multiple partition?
What is the difference between the conventional and direct path loader? : aql loader
Is a view faster than a stored procedure?
What are triggers in sql?
what is denormalization. : Sql dba
How do I make my sql query run faster?