Resume Pertemuan 2 PBD

CONTOH SYNTAX DEKLARASI DALAM PL/SQL

a) declare
@nim varchar2 (11)
begin
select @nim : nim from mhs
where nim = ’08410100205′
end;

b) declare
@nama varchar (100),
@nik varchar (100),
set @nik = ’100301′
begin
select @nama = nama drom kar
where nik = @nik
print @nama
end;

contoh syntax deklarasi dalam Oracle
a) declare
nama varchar2 (100)
begin
select nama into nama from kar
where nik = ’100301′;
dbms_output.put_line (nama);

b) declare
nama varchar2 (100);
nik varchar2 (11);
alamat varchar2 (100);
begin
select nama, nik alamat into nama, nik, alamat from kar
where nik = ’100308′
dbms_output.put_line (‘nama’||’ ‘ ||nama||’ ‘||’alamat’||alamat);
contoh percabangan oracle
declare
kelamin varchar2 (4);
nama varchar2 (100) := ‘tito’;
begin
if nama = ‘tito then
kelamin := ‘laki’;
elsif nama = ‘dwo’ then
kelamin := ‘perempuan’;
else
kelamin := ‘bencong’;
endif
dbms_output.put_line(‘jika :’||’ ‘ ||kelamin))
perulangan di oracle
loop
declare
nilai number (2) := 1;
begin
loop

DBMS_OUTPUT.PUT_LINE(‘nilai : ‘||nilai);
nilai := nilai + 1 ;
exit when nilai > 10;
end loop;
end;
percabangan SQL
declare
@nama varchar (100);
@nik varchar (100)
set @nik = ’100307′
begin
select @nama = nama from kar
when nik = @nik
if @nama = ‘teguh’
begin
print ‘oke’
end
else
begin
print ‘sip’
end
end;