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
- 8306 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / rohit
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
for i in cur_name loop
v_count :=nvl(cur_name%rowcount ,0);
exit when cur_name%notfound;
end loop;
dbms_output.put_line(v_count);
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;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is coalesce sql?
What are the different sql commands?
How is use pl and sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is replication id?
What is the difference between view and stored procedure?
What is the least restrictive isolation level? : Transact sql
Differentiate between pl/sql and sql?
How to order siblings in oracle hierarchy queries?
What is sql*loader?
How do you create an update query?
How to place comments in pl/sql?
How to prepare for oracle pl sql certification?
What are the advantages of stored procedure?
what are date and time intervals? : Sql dba
