Galeri

Cara memasang Shoutmix di Blog

Masukkan script dibawah ini ke widget blog kamu: <!– Begin ShoutMix – http://www.shoutmix.com –> <iframe scrolling=”auto” width=”200″ frameborder=”1″ src=”http://www4.shoutmix.com/?khaireza&#8221; height=”400″ title=”khaireza”> <a href=”http://www4.shoutmix.com/?khaireza”>View shoutbox</a> </iframe> <br/><a href=”http://www.shoutmix.com”></a&gt; ============================================================= PENTING!! jika akan memasukkan script pada postingan masukan duluĀ  script ini <p> … Baca lebih lanjut

Galeri

Membuat Tabel menggunakan php

Table pemilik>> create table pemilik( id_pemilik varchar(20) not null, nama varchar(20) not null, alamat varchar(20) not null, constraint pk_id_pemilik primary key(id_pemilik) ); ==================================================== Table counter>> create table counter( id_counter varchar(20) not null, nama_counter varchar(20) not null, id_pemilik varchar(20) not null, … Baca lebih lanjut

Galeri

Membuat Trigger via Oracle

======================================== Membuat Trigger ==================================================== CREATE OR REPLACE TRIGGER secure_emp BEFORE INSERT ON employees BEGIN IF (TO_CHAR(SYSDATE,’DY’) IN (‘MON’)) OR (TO_CHAR(SYSDATE, ‘HH24:MI’) BETWEEN ’08:00′ AND ’18:00′) THEN RAISE_APPLICATION_ERROR(-20500, ‘You may insert’|| ‘ into EMPLOYEES table only during ‘ || ‘ business … Baca lebih lanjut

Galeri

Membuat Function via Oracle

======================================== Menampilkan salary berdasarkan employee_id ==================================================== CREATE OR REPLACE FUNCTION get_sal (id employees.employee_id%type) RETURN number IS sal employees.salary%type :=0; BEGIN SELECT salary INTO sal FROM employees WHERE employee_id=id; RETURN sal; END get_sal; / ————————————————————————- EXECUTE dbms_output.put_line(get_sal(100)) ———————————————————————–

Galeri

Membuat Procedure via Oracle

================================ *Procedure Insert ke tabel =============================================== create or replace procedure ADD_JOB (id IN JOBS.JOB_ID%TYPE, title IN JOBS.JOB_TITLE%TYPE) IS BEGIN INSERT INTO JOBS(JOB_ID, JOB_TITLE) VALUES (id, title); END ADD_JOB; / ————————————————————————————— execute ADD_JOB(‘IT_DBA’, ‘DATABASE ADMINISTRATOR’) —————————————————————————————- select * from JOBS; ————————————————————————————- … Baca lebih lanjut

Galeri

Membuat DECISION BLOCK via Oracle

======================================== Membuat Decision Block ==================================================== set serveroutput on; declare nilai number :=&in_nli_id; begin if nilai<45 then dbms_output.put_line(‘Grade Anda E’); elsif nilai<60 then dbms_output.put_line(‘Grade Anda D’); elsif nilai<75 then dbms_output.put_line(‘Grade Anda C’); elsif nilai<85 then dbms_output.put_line(‘Grade Anda B’); else dbms_output.put_line(‘Grade Anda … Baca lebih lanjut

Galeri

Script php untuk membuat bintang versi 2

======================================== Bintang versi 2 ==================================================== **** *** ** * ======================================== set serveroutput on; declare a number:=&angka; b number; c number; begin for b in reverse 1..a loop for c in reverseĀ  1..b loop dbms_output.put(‘*’); end loop; dbms_output.new_line(); end loop; end; … Baca lebih lanjut

Galeri

Script php untuk membuat bintang versi 1

======================================== Bintang versi 1 ==================================================== * ** *** **** ================================== set serveroutput on; declare a number:=&angka; b number; c number; begin for b in 1..a loop for c in 1..b loop dbms_output.put(‘*’); end loop; dbms_output.new_line(); end loop; end; / =============================================

Galeri

Kisi2 UAS SISTEL

Rangkuman – 8 Jaringan wireless/nirkabel adalah teknologi jaringan yang memanfaatkan gelombang elektromagnetik melalui udara sebagai media untuk mengirimkan informasi dari pengirim ke penerima. Beberapa teknologi wireless yang telah dikembangkan antara lain : WiFi, Bluetooth, WiMAX (World-wide interoperability Microwave Access), VSAT, … Baca lebih lanjut