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
- 7439 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
how to shut down the server with 'mysqladmin'? : Sql dba
What is the purpose of design view?
What is sap sql anywhere?
What is the use of function in sql?
What is string data type in sql?
What is not equal in sql?
What is procedure function?
What is crud stand for?
What are different types of sql?
How can we debug in PL/SQL?
What are all the ddl commands?
What is a primary key called that is made up of more than one field?
what is the different between now() and current_date()? : Sql dba
What is scalar function in sql?
What is the difference between a procedure and a function?
