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
- 8026 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 does select top 1 do in sql?
Explain what is a view?
What is the plv (pl/vision) package offers?
how to run 'mysql' commands from a batch file? : Sql dba
what is commit? : Sql dba
what is 'mysqldump'? : Sql dba
what is the difference difference between procedure and packages
Can we create index on primary key?
what is foreign key? : Sql dba
Why use subqueries instead of joins?
What is orm in sql?
Where is sql database stored?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is information schema in sql?
What is pls_integer in pl sql?
