Technicalsymposium



Join Our Email Alerts-Subscribe
Important Note:Login & Check Your Email Inbox and Activate Confirmation Link


Enter Your Email :

PL SQL Program For function using exception.

create or replace function stinfo(no in number) return varchar2 is snam varchar2(30);
begin
select name into snam from student where stuid=no;
return snam;
exception
when no_data_found then
return(' Record does not exist ');
end;


All Programming Codes/Onlie Training/ Lab Manuals Download