Interested to Buy Any Domain ? << Click Here >> for more details...
declare
v_count number(8,3);
v_sal scott.emp.sal%type := '&P_sal';
cursor cur_name is select sal from scott.emp where sal
between (v_sal-100) and (v_sal +1000);
begin
v_count :=nvl(sql%rowcount ,0);
if v_count = 0 then
dbms_output.put_line('no records are fetch in the given sal
range');
else
dbms_output.put_line('There is/are '||to_char(v_count)||
' salaries are selected in the given range ');
end if;
end;
in the above programm .....for any sal range ....always it
shows the following message..
no records are fetch in the given sal range
please find the mistake and share with me...with thansk and
regards..sarao....
- 3 Answers
- 8304 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / debasis mohanty
First We Have To Open Cursor
Then We Use Any Loop For That.
(because number of rows selected if we use loop)
After that Condition.
So That We Get Appropriate Answer.
Thanks & Regards
Debasis
dmddebasismohanty183@gmail.com
08722140827
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is varchar data type in sql?
What is a sql profiler?
What is pls_integer in pl sql?
Can a primary key be a foreign key?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how is myisam table stored? : Sql dba
What is an oracle stored procedure?
What is the difference between distinct and unique in sql?
What is the difference between pl and sql?
Why is partition used in sql?
Which sorts rows in sql?
How insert into statements in sql?
What is the difference between the implicit and explicit cursors?
How many row comparison operators are used while working with a subquery?
What is the difference between stored procedure and view?
