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
I will be able to say that you've got a finished a quality job here to share that article with us. You may have determined it after some study and thus unquestionably in any respect that it's going to aid us all. I am right here to appear for some knowledge in regards to one in all my outdoor media . I am hoping it helps me to get stimulated and located a solution for my issue soon.
ReplyDeletekeep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me
ReplyDeleteDot Net training in chennai
This is a great article, I have been always to read something with specific tips! I will have to work on the time for scheduling my learning.
ReplyDeleteAntifungal Cream
Vitiligo Medicines
Herbal Tonic
Anybody want to know How to trace the mobile with location and get more details for tracking.Read this blog...
ReplyDeleteMobile Number Tracker | Phone Number Tracker With Location | Mobile Location Tracker | How To Track A Phone Number | Phone Number Tracker | Phone Number Search
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
A great content and very much useful to the visitors. looking for more updates in future.
ReplyDeletePython Training in Chennai