declare
v_foundrows boolean := false;
begin
for r in ( select * from employees where employee_id= &dno )
loop
dbms_output.put_line(r.last_name || ' ' || r.salary);
v_foundrows := true;
end loop;
if not v_foundrows then
raise no_data_found;
end if;
exception
when no_data_found then
dbms_output.put_line('hello');
end;
v_foundrows boolean := false;
begin
for r in ( select * from employees where employee_id= &dno )
loop
dbms_output.put_line(r.last_name || ' ' || r.salary);
v_foundrows := true;
end loop;
if not v_foundrows then
raise no_data_found;
end if;
exception
when no_data_found then
dbms_output.put_line('hello');
end;
ya it is really i had a fun and auspicious time by reading your blog thus it makes me to be proud to get many more credentials.
ReplyDeletethus i had a good time with your blog it attracts me with large types of collections.
salesforce Training instiute in Chennai
keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me
ReplyDeleteDot Net training in chennai
Like To Read your Post Because Your Post Is very interesting thank you so much give us information keep posting good luck ……………….
ReplyDeletehttp://nishakohli.com/andheri-escorts.html