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....
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
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is data modelling in sql?
What is view explain with example?
What is pivot table in sql?
What are the different sql commands?
Explain the structure of pl/sql in brief.
How do you truncate?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What are the advantages of normalization?
What is denormalization in a database?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
Which join condition can be specified using on clause?
What is nosql example?
What version is sql?