|
|
| PL/SQL Tutorial
Using If condition in Pl/SQL Sample code
|
|
declare
begin
if to_char(sysdate,'day')='wednesday' then
dbms_output.put_line('today is wed');
end if;
end;
declare
begin
if(5=4) then
dbms_output.put_line(to_char(sysdate,'day'));
else
dbms_output.put_line('jjj');
end if;
end;
|
Using Goto condition in Pl/SQL Sample code
declare
2 x number :=0;
3 begin
4 for x in 1..5 loop
5 if(x=4) then
6 goto vvv;
7 else
8 dbms_output.put_line('xvb'||'eed');
9 end if;
10 end loop;
11 <<vvv>>
12 null;
13 end;
14 /
Go To
Index
|
|
|
