{ Berbagi, Menulis, Dan Mengajar } Ilmu…

SQL> -- create demo table SQL> create table Employee( 2 ID                 VARCHAR2(4 BYTE) NOT NULL, 3 First_Name         VARCHAR2(10 BYTE), 4 Last_Name          VARCHAR2(10 BYTE), 5 Start_Date         DATE, 6 End_Date           DATE, 7 Salary             Number(8,2), 8 City               VARCHAR2(10 BYTE), 9 Description        VARCHAR2(15 BYTE) 10 ) 11 / Table created. SQL> SQL> create table employee_audit ( 2 id VARCHAR2(4 BYTE), 3 salary Number(8,2), 4 delete_date Date, 5 deleted_by VARCHAR2(15 BYTE) 6 ) 7 / Table created. SQL> SQL> SQL> -- prepare data SQL> insert into Employee(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description) 2 values ('01','Jason',    'Martin', to_date('19960725','YYYYMMDD'), to_date('20060725','YYYYMMDD'), 1234.56, 'Toronto',  'Programmer') 3 / 1 row created. … Read entire article »

DELIMITER $$ USE `sms2`$$ DROP TRIGGER /*!50032 IF EXISTS */ `DeletePbk`$$ CREATE /*!50017 DEFINER = ‘dimas’@’%’ */ TRIGGER `DeletePbk` AFTER DELETE ON `pbk` FOR EACH ROW BEGIN DELETE FROM pbk_copy WHERE pbk_copy.id_pbk=OLD.id_pbk; END; $$ DELIMITER ; … Read entire article »

DELIMITER $$ USE `sms2`$$ DROP TRIGGER /*!50032 IF EXISTS */ `CopyPbk`$$ CREATE /*!50017 DEFINER = ‘dimas’@’%’ */ TRIGGER `CopyPbk` AFTER INSERT ON `pbk` FOR EACH ROW BEGIN INSERT INTO sms2.pbk_copy (GroupID,NAME,SenderNumber,DestinationNumber,id_pbk) VALUE ( NEW.GroupID,NEW.NAME,NEW.Number,NEW.Number,NEW.id_pbk); END; $$ DELIMITER ; … Read entire article »

TATA CARA INSTALLASI PROGRAM SMS CENTER … Read entire article »

Qmailrocks friendyogi … Read entire article »

Nek 1.) mwn username :   noorman_rinanto@yahoo.com 2.) pandi username:  nman1976 –> Pass sama semua: sakti2010 —   Informasi Pengguna Update Informasi Pengguna Update Kata Sandi Update bahasa   Nama Awal * Dimas Nama Akhir * Adityo E-mail * dms@ikc.co.id Nama Organisasi * POLSAS Negara * Indonesia Kode Pos * 60185 Provinsi * Jawa Timur Kota * Surabaya Jalan1 * PERUMDOS ITS / N-1 Jalan2 Jalan3 Telepon * +62.8123006030 … Read entire article »

http://www.sendsms.cn/download/ … Read entire article »

DATA KUMHAM DataKumHam per tgl 10-08-2011 DataPegawaiBesar09082011C … Read entire article »

http://www.google.co.id/#hl=id&source=hp&q=eset+nod32+username+and+password&oq=ESET+NOD&aq=1&aqi=g10&aql=&gs_sm=e&gs_upl=2803839l2805301l0l2809405l8l8l0l1l1l0l279l1376l0.4.3l7l0&fp=383c4d4880a1449f&biw=1366&bih=675 … Read entire article »

Lightning Fast PHP Server With Nginx, eAccelerator, and Varnish _ Travis Berry_files … Read entire article »