sql%rowcount issue
913578Jan 15 2013 — edited Jan 15 2013hi,
i am using oracle 11g2.0
declare
begin
select * from emp where sal>1000;
if sql%rowcount>1
then
dbms_output.put_line('There are few employees with sal>1000');
else
dbms_output.put_line('There are no employees with sal>1000');
end if;
end;
my question is will SQL%ROWCOUNT works for sql query? if there are 4 records in emp table with sal>1000 then the message 'There are few employees with sal>1000' will displayed?
please help me.