Rabu, 21 September 2011

Pemograman Berbasis Obyek - 02

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