Declaring Variabel
* Query Black
contoh : declare
@ nim varchar2(1)
begin
select + @nim = nim from mhs
where nim = '09410100079'
end;
* Untuk Meng-eneble SQL
set serveroutput ON
* SQL Server
# PL / SQL
declare
@ nama = nama varchar (100)
@ nik = nik varchar (10)
set nik = '090079'
begin
select @nama = nama from kar
where nik = @nik
print @nama
end;
Tidak ada komentar:
Posting Komentar