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
- 8305 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sai
First open the cursor and fetch the records then u get the
required output.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can a table contain multiple foreign key’s?
What is %type in pl sql?
What is rollback?
Is sqlexception checked or unchecked?
Explain architecture of sql server notification services?
What is the use of partition by in sql?
What is mutating error in pl sql?
How to order siblings in oracle hierarchy queries?
Which is better join or subquery?
How does postgresql compare to "nosql"?
What is a primary key called that is made up of more than one field?
how many ways we can we find the current date using mysql? : Sql dba
Explain the the update statement in sql?
What is an intersect?
How do I remove duplicates in two columns?
