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
- 8184 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 record type in pl sql?
what is msql? : Sql dba
What are the indexing methods?
Can we use loop in sql?
Does mysql_real_escape_string prevent sql injection?
What are character functions in sql?
What are the types of dbms?
What is trigger in sql and its types?
What is an ndf file?
Can we write ddl statements in functions?
Is grant a ddl statement?
Can we create table inside stored procedure?
Does asenumerable execute the query?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are all the different normalization?
