· #
declare
nama varchar
2(100)
begin
select nama into nama from kar
where nik = ‘100307’;
DBMS_OUTPUT.PUT_LINE
<nama>;
end
· #
define nik =’100307’
declare
nama varchar 2 (100)
begin
select nama into nama from kan
where nik = nik
DBMS_OUTPUT.PUT_LINE <nama>;
end
· # declare
@nama varchar
(100)
@nik varchar (100)
set @ nik
=’100307’
begin
select @nama =
nama from kan
where nik = @nik
print @nama
end;
·
# declare
nik varchar 2 (100); = ‘suhendra’;
kelamin
varchar 2 (100);
begin
if
nama = ‘suhendra’ then
kelamin
=’laki-laki’;
else
kelamin=’perempuan’
end if;
DBMS_OUTPUT.PUT_LINE(‘jika:
‘II’’II kelamin);
end;
· # declare
@nama varchar (100),
@nik varchar(100)
Set
@nik=’100307’
begin
select@nama=nama
from kar
where
nik=@nik
if
@nama=’arliq’
begin
print
‘ok’
end
else
begin
print’sip’
end
end;
Tidak ada komentar:
Posting Komentar