Educational Materials like Computer, engineering, software and Property , Entertainment: Check exists validation using pl/sql
Custom Search

Subscribe Now: Feed Icon

February 4, 2012

Check exists validation using pl/sql

Check exists validation using pl/sql

declare
v_deptno dept.deptno%type:=&gdeptno;
cursor deptcursor
is
select * from dept where deptno=v_deptno;
v_deptcursor deptcursor%rowtype;
begin
open deptcursor;
fetch deptcursor into v_deptcursor;
if deptcursor%found then
dbms_output.put_line('v_deptcursor.ename);
else
dbms_output.put_line('sorr..! no deptloyee exists..');
end if;
end;

0 comments:

Post a Comment

Follow by Email

Video Bar

Loading...

Followers

Educational Materials like Computer, engineering, software and Property , Entertainment

Recent Visitors

Active Search Results
Wink Bingo | Slots Tips | Football manager 2010 | blackjack free | Poker Stars
Submitdomainname.com