API tools faq
paste
Guest User

Untitled

a guest
Nov 27th, 2018
131
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.33 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE Apoteker(
  2. nama VARCHAR(20),
  3. alamat VARCHAR(70),
  4. nip CHAR(18) NOT NULL ENABLE,
  5. jenis_kelamin CHAR(1),
  6. no_telp CHAR(12),
  7. tanggal_lahir DATE,
  8. CONSTRAINT apoteker_pk PRIMARY KEY (nip) ENABLE
  9. );
  10.  
  11. CREATE TABLE Stock_Keeper(
  12. nama VARCHAR(20),
  13. alamat VARCHAR(70),
  14. nip CHAR(18) NOT NULL ENABLE,
  15. jenis_kelamin CHAR(1),
  16. no_telp CHAR(12),
  17. tanggal_lahir DATE,
  18. no_resi CHAR(6) NOT NULL,
  19. CONSTRAINT stock_keeper_pk PRIMARY KEY (nip) ENABLE
  20. );
  21.  
  22. CREATE TABLE Supplier(
  23. id CHAR (10) NOT NULL ENABLE,
  24. nama VARCHAR(30),
  25. email VARCHAR(40),
  26. alamat VARCHAR(100),
  27. no_telp CHAR(12),
  28. CONSTRAINT supplier_pk PRIMARY KEY (id) ENABLE
  29. );
  30.  
  31. CREATE TABLE Pembeli(
  32. nama VARCHAR(20),
  33. alamat VARCHAR(100),
  34. nik CHAR(16) NOT NULL ENABLE,
  35. jenis_kelamin CHAR(1),
  36. no_telp CHAR(12),
  37. tanggal_lahir DATE,
  38. CONSTRAINT pembeli_pk PRIMARY KEY (nik) ENABLE
  39. );
  40.  
  41. CREATE TABLE Obat(
  42. id CHAR(6) NOT NULL ENABLE,
  43. nama VARCHAR(20),
  44. dosis VARCHAR(70),
  45. sediaan VARCHAR(120),
  46. stok NUMBER,
  47. harga NUMBER,
  48. CONSTRAINT obat_pk PRIMARY KEY (id) ENABLE
  49. );
  50.  
  51. CREATE TABLE Membeli(
  52. nik CHAR(16) NOT NULL,
  53. id_obat CHAR(6) NOT NULL,
  54. nip CHAR(18) NOT NULL,
  55. no_transaksi CHAR(6) NOT NULL,
  56. banyaknya NUMBER
  57. );
  58.  
  59. CREATE TABLE Menyuplai(
  60. id_obat CHAR(6) NOT NULL,
  61. id_supplier CHAR(10) NOT NULL,
  62. no_resi CHAR(6) NOT NULL,
  63. CONSTRAINT menyuplai_pk PRIMARY KEY (no_resi) ENABLE
  64. );
  65.  
  66. ALTER TABLE Stock_Keeper ADD CONSTRAINT stock_keeper_fk1 FOREIGN KEY (no_resi)
  67. REFERENCES Menyuplai (no_resi) ON DELETE CASCADE;
  68. ALTER TABLE Membeli ADD CONSTRAINT membeli_fk1 FOREIGN KEY (nik)
  69. REFERENCES Pembeli (nik) ON DELETE CASCADE;
  70. ALTER TABLE Membeli ADD CONSTRAINT membeli_fk2 FOREIGN KEY (id_obat)
  71. REFERENCES Obat (id_obat) ON DELETE CASCADE;
  72. ALTER TABLE Membeli ADD CONSTRAINT membeli_fk3 FOREIGN KEY (nip)
  73. REFERENCES Apoteker (nip) ON DELETE CASCADE;
  74. ALTER TABLE Menyuplai ADD CONSTRAINT menyuplai_fk2 FOREIGN KEY (id_supplier)
  75. REFERENCES Supplier (id) ON DELETE CASCADE;
  76. ALTER TABLE Menyuplai ADD CONSTRAINT menyuplai_fk1 FOREIGN KEY (id_obat)
  77. REFERENCES Obat (id) ON DELETE CASCADE;
  78.  
  79. alter session set nls_date_format= 'DD-MM-YYYY';
  80.  
  81. INSERT INTO Apoteker VALUES('Antonio','Jl. Buah batu No.1','197001012000031001','L','08123117001','01-01-1970');
  82. INSERT INTO Apoteker VALUES('Budi','Jl. Pelajar Pejuang No. 1','197001282000031002','L','08123117002','28-01-1970');
  83. INSERT INTO Apoteker VALUES('Caca','Jl. Pelajar Pejuang No. 2','197102022000032003','P','08123117003','02-02-1971');
  84. INSERT INTO Apoteker VALUES('Ari','Jl. Dayeuhkolot No. 1','197102272000031004','L','08123117004','27-02-1971');
  85. INSERT INTO Apoteker VALUES('Rahmi','Jl. Baleendah No. 1','197203032000032005','P','08123117005','03-03-1972');
  86. INSERT INTO Apoteker VALUES('Rusli','Jl. Moh Toha No. 1','197203262000031006','L','08123117006','26-03-1972');
  87. INSERT INTO Apoteker VALUES('Fahmi','Jl. Batu Nunggal No. 1','197304042000031007','L','08123117007','04-04-1973');
  88. INSERT INTO Apoteker VALUES('Doni','Jl. Sukapura No. 1','197304252000031008','L','08123117008','25-04-1973');
  89. INSERT INTO Apoteker VALUES('Fajar','Jl. Sukabirus No. 1','197405052000031009','L','08123117009','05-05-1974');
  90. INSERT INTO Apoteker VALUES('Tati','Jl. Dayeuhkolot No. 2','197405242000032010','P','08123117010','24-05-1974');
  91. INSERT INTO Apoteker VALUES('Dono','Jl. Baleendah No. 2','197506062000031011','L','08123117011','06-06-1975');
  92. INSERT INTO Apoteker VALUES('Joko','Jl. Moh Toha No. 2','197506232000031012','L','08123117012','23-06-1975');
  93. INSERT INTO Apoteker VALUES('Dinda','Jl. Batu Nunggal No. 2','197607072000032013','P','08123117013','07-07-1976');
  94. INSERT INTO Apoteker VALUES('Bambang','Jl. Sukabirus No. 2','197607222000031014','L','08123117014','22-07-1976');
  95. INSERT INTO Apoteker VALUES('Surti','Jl. Sukabirus No. 3','197708082000032015','P','08123117015','08-08-1977');
  96. INSERT INTO Apoteker VALUES('Harti','Jl. Moh Toha N0. 3','197708232000032016','P','08123117016','23-08-1977');
  97. INSERT INTO Apoteker VALUES('Putri','Jl. Dayeuhkolot No. 3','197809092000032017','P','08123117017','09-09-1978');
  98. INSERT INTO Apoteker VALUES('Keke','Jl. Buah batu N0. 2','197810222000032018','P','08123117018','22-10-1978');
  99. INSERT INTO Apoteker VALUES('Hendra','Jl. Buah batu No. 3','197911212000031019','L','08123117019','21-11-1979');
  100. INSERT INTO Apoteker VALUES('Ujang','Jl. Pelajar Pejuang N0. 3','198012302000031020','L','08123117020','30-12-1980');
  101.  
  102.  
  103. INSERT INTO supplier VALUES('sp001','PT Tempo','PtTempo@gmail.com','Jl. Soekarno-Hatta No. 604 Km. 9,5 Bandung','0227562072');
  104. INSERT INTO supplier VALUES('sp002','PT Tiara Kencana','PtTiaraKencana@gmail.com','Jl. Sriwijaya No. 120 Bandung','0225206523');
  105. INSERT INTO supplier VALUES('sp003','PT Tiga A','PtTiga A@gmail.com','Jl. Pungkur No. 41 Rt 05/03 Kel Balonggede - Kec Regol Bandung 40251','0224204117');
  106. INSERT INTO supplier VALUES('sp004','PT Tigaka Distrindo Perkasa','PtTigakaDistrindoPerkasa@gmail.com','Jl. Gegerkalong Hilir No. 153 Bandung ','022214134');
  107. INSERT INTO supplier VALUES('sp005','Tira Wirajaya, PT','PtTiraWirajaya@gmail.com','Jl. MM Mustofa No. 7 A Bandung','022737721');
  108. INSERT INTO supplier VALUES('sp006','Tjatur Dianson Farma, PT','PtTjaturDiansonFarma@gmail.com','Jl. Saturnus Selatan No. 2 Kompl. Margahayu Raya Bandung','022762018');
  109. INSERT INTO supplier VALUES('sp007','Tjipta Niaga, PT','PtTjiptaNiaga@gmail.com','Jl. Jawa No. 12 Bandung','0224204024');
  110. INSERT INTO supplier VALUES('sp008','Tiara Kencana, PT','PtTiaraKencana@gmail.com','Jl. Sriwijaya No. 120 Bandung','0225206523');
  111. INSERT INTO supplier VALUES('sp009','Tiputra Maju Sentosa','TiputraMajuSentosa@gmail.com','Jl. Merkuri Utara Iv No.12 Rt 06/21 Kel Sekejati - Kec Margacinta Bandung','0227502916');
  112. INSERT INTO supplier VALUES('sp010','Tira Wirajaya, PT','PtTiraWirajaya@gmail.com','JL. MM Mustofa No. 7 A Bandung','022737721');
  113. INSERT INTO supplier VALUES('sp011','Tirta Husada Farma, PT','PtTirtaHusadaFarma@gmail.com','Jl. Jendr Gatot Subroto No. 21 Bandung','02256868');
  114. INSERT INTO supplier VALUES('sp012','PT DKSH','PtDKSH@gmail.com','Jl. Sidomukti No.55 Rt 09/02 Kel Sukaluyu - Kec Cibeunying Kaler, Bandung','0222500396');
  115. INSERT INTO supplier VALUES('sp013','UNITED CITO CITAS, PT','PtUnitedCitoCitas@gmail.com','Jl. Cihampelas No.21 Rt 03/03 Kel Pasirkaliki - Kec Cicendo, Bandung','0224236819');
  116. INSERT INTO supplier VALUES('sp014','WAHONO TARUNA SAKTI, PT','PtWahonoTarunaSakti@gmail.com','Jl. Mahmud No. 2 Bandung, Jawa Barat','0221487618');
  117. INSERT INTO supplier VALUES('sp015','WIGO HOSLAB, PT','PtWigoHoslab,@gmail.com','Jl. Pahlawan No. 55 Bandung','0222508530');
  118. INSERT INTO supplier VALUES('sp016','WIHADI WYDIA, PT','PtWihadiWydia@gmail.com','Jl. Sukamaju No.42 Rt 01/11 Kel Pasteur - Kec Sukajadi, Bandung Jawa Barat','0222039090');
  119. INSERT INTO supplier VALUES('sp017','Alida Perintis Jaya, PT','PtAlidaPerintisJaya@gmail.com','Jl. Babakan Tarogong No. 110 Bandung,','0226045602');
  120. INSERT INTO supplier VALUES('sp018','Aniza Burhan Bersaudara, PT','PtAnizaBurhanBersaudara@gmail.com','Jl. Sukahaji No. 125 A Bandung','0226527871');
  121. INSERT INTO supplier VALUES('sp019','Antar Mitra Sembada, PT','PtAntarMitraSembada@gmail.com','Jl. LMU Nurtanio No. 85 Bandung','0226031594');
  122. INSERT INTO supplier VALUES('sp020','Yunia Yoga Farma, PT','PtYuniaYogaFarma@gmail.com','Jl. Pasirluyu V No.15 Rt 01/08 Kel Ancol - Kec Regol Bandung 40254','0225200839');
  123.  
  124. INSERT INTO Pembeli VALUES('Rakes','Jl Perumahan Buah Batu No. 1','3273220101900001','L','081266778899','01-01-1990');
  125. INSERT INTO Pembeli VALUES('Iben','Jl. Cherry Field No. 1','3273222801900002','L','081266778900','28-01-1990');
  126. INSERT INTO Pembeli VALUES('Lula','Jl. PGA N0. 1','3273224202910003','P','081266778901','02-02-1991');
  127. INSERT INTO Pembeli VALUES('Iday','Jl. Sukabirus N0. 1','3273222702910004','L','081266778902','27-02-1991');
  128. INSERT INTO Pembeli VALUES('Alvinda','Jl. Sukapura No. 1','3273224303920005','P','081266778903','03-03-1992');
  129. INSERT INTO Pembeli VALUES('Dela','Jl. Pesona Bali Residence No. 1','3273226603920006','P','081266778904','26-03-1992');
  130. INSERT INTO Pembeli VALUES('Faris','Jl. Gelora Bandung Asri N0. 1','3273220404930007','L','081266778905','04-04-1993');
  131. INSERT INTO Pembeli VALUES('Fandi','Jl Perumahan Buah Batu No. 2','3273222504930008','L','081266778906','25-04-1993');
  132. INSERT INTO Pembeli VALUES('Fadil','Jl. Cherry Field No. 2','3273220505940009','L','081266778907','05-05-1994');
  133. INSERT INTO Pembeli VALUES('Janu','Jl. PGA N0. 2','3273222405940010','L','081266778908','24-05-1994');
  134. INSERT INTO Pembeli VALUES('Annas','Jl. Sukabirus N0. 2','3273220606950011','L','081266778909','06-06-1995');
  135. INSERT INTO Pembeli VALUES('Wira','Jl. Sukapura No. 2','3273222306950012','L','081266778910','23-06-1995');
  136. INSERT INTO Pembeli VALUES('Gillang','Jl. Pesona Bali Residence No. 2','3273220707960013','L','081266778911','07-07-1996');
  137. INSERT INTO Pembeli VALUES('Vinny','Jl. Gelora Bandung Asri N0. 2','3273222207960014','L','081266778912','22-07-1996');
  138. INSERT INTO Pembeli VALUES('karim','Jl Perumahan Buah Batu No. 3','3273220808970015','L','081266778913','08-08-1997');
  139. INSERT INTO Pembeli VALUES('Ambar','Jl. Cherry Field No. 3','3273222108970016','P','081266778914','21-08-1997');
  140. INSERT INTO Pembeli VALUES('Ryan','Jl. PGA N0. 3','3273220909980017','L','081266778915','09-09-1998');
  141. INSERT INTO Pembeli VALUES('Rafid','Jl. Sukabirus N0. 3','3273222010980018','L','081266778916','20-10-1998');
  142. INSERT INTO Pembeli VALUES('Ilham','Jl. Sukapura No. 3','3273221011990019','L','081266778917','10-11-1999');
  143. INSERT INTO Pembeli VALUES('Veshea','Jl. Pesona Bali Residence No. 3','3273223012000020','P','081266778918','30-12-2000');
  144.  
  145. INSERT INTO obat VALUES('obt001','Amoxicillin','20-40mg/kgBB/hari (3x)','Caps 250mg, Kaptab500mg, Syr125;250mg/5ml, Inj. 1g/vial',21,4500);
  146. INSERT INTO obat VALUES('obt002','Ampicillin','50-100mg/kgBB/hari (4x)IV: 100-200mg/kgBB/hari (4x)','Caps 250mg, Kaptab500mg, Syr125;250mg/5ml, Inj.0,5;1g/vial',30,18900);
  147. INSERT INTO obat VALUES('obt003','As. Nalidiksat','55mg/kgBB/hari (4x','Tab 500mg',27,20000);
  148. INSERT INTO obat VALUES('obt004','Ceftriaxone','50-80mg/kgBB/hari (1x)','Inj. 500mg;1g/vial (IM/IV)',33,8000);
  149. INSERT INTO obat VALUES('obt005','Cefixime','3-10mg/kgBB/hari (2x)','Caps 50;100mg, Syr100mg/5ml',24,12000);
  150. INSERT INTO obat VALUES('obt006','Cefadroxil','25-30mg/kgBB/hari (2x)Dewasa 500mg/kali (2-4x)','Caps 250;500mg, Syr125;500mg/5ml',26,1500);
  151. INSERT INTO obat VALUES('obt007','Cefuroxime','20mg/kgBB/hari (2x)','Tab 500mg, Kap250;500mg, Inj.750mg;1g/vial',11,10000);
  152. INSERT INTO obat VALUES('obt008','Cefotaxime','Anak: 50-100mg/kgBB/hari(3x)BB <50kg: 100-200mg/kgBB/hari (3-4x)IM/IV BB>50kg: 1-2g (3-4x)Dewasa: 1g/kali (2x)','Inj. 500mg;1g/vial',30,11500);
  153. INSERT INTO obat VALUES('obt009','Cotrimoxazole','T: 6-12mg/kgBB/hari (2x)S: 30-50mg/kgBB/hari (2x)','Pedtab 120mg, Tab480;960mg, Susp.240mg/5ml',17,1600);
  154. INSERT INTO obat VALUES('obt010','Chloramphenicol','Usia >1bln: 50-75mg/kgBB/hari (4x','Caps 250;500mg, Syr125mg/5ml, Inj. 1g/vial',18,4600);
  155. INSERT INTO obat VALUES('obt011','INH','10-15mg/kgBB/hari','Tab 100;300mg, Syr 10mg/ml',29,45000);
  156. INSERT INTO obat VALUES('obt012','Rifampisin','10-20mg/kgBB/hari (1-2x)','Caps-Tab 150;300;450;600mg,Syr 20mg/ml',29,11000);
  157. INSERT INTO obat VALUES('obt013','Dexamethasone','Anak: 0,006-0,4mg/kgBB/hariDewasa: 0,2-0,5mg/kgBB/hari','LD: 0,5-1mg/kgBB bolusMD: 1mg/kgBB/hari (3-4x)IV/IM',15,185000);
  158. INSERT INTO obat VALUES('obt014','Prednison','1-2mg/kgBB/hari (3x)','Tab 5mg',27,12800);
  159. INSERT INTO obat VALUES('obt015','Salbutamol','0,1-0,15mg/kgBB/kali (3-4x)','Tab 2;4mg, Syr2mg/5ml',23,2500);
  160. INSERT INTO obat VALUES('obt016','Prednisolon','1-2mg/kgBB/hari (4x)','Tab 4mg',34,1600);
  161. INSERT INTO obat VALUES('obt017','Mebhidrolin','7,5mg/kgBB/hari (3x)','Tab 50mg, Syr 50mg/5ml',20,10000);
  162. INSERT INTO obat VALUES('obt018','Hemoklorsiklin','0,15mg/kgBB/hari (3x)','Tab 10mg',22,17000);
  163. INSERT INTO obat VALUES('obt019','Misoprostol','200mcg/hari (4x)','Tab 200mcg',28,500000);
  164. INSERT INTO obat VALUES('obt020','Hiasin','1-4gtt (3x)','Drop 1mg/ml',25,13000);
  165.  
  166. INSERT INTO Membeli VALUES('3273220101900001','obt001','197001012000031001','000001',3);
  167. INSERT INTO Membeli VALUES('3273220101900001','obt002','197001012000031001','000001',2);
  168. INSERT INTO Membeli VALUES('3273220101900001','obt003','197001012000031001','000001',4);
  169. INSERT INTO Membeli VALUES('3273222702910004','obt004','197102272000031004','000002',1);
  170. INSERT INTO Membeli VALUES('3273222702910004','obt001','197102272000031004','000002',5);
  171. INSERT INTO Membeli VALUES('3273222702910004','obt006','197102272000031004','000002',7);
  172. INSERT INTO Membeli VALUES('3273220404930007','obt004','197304042000031007','000003',2);
  173. INSERT INTO Membeli VALUES('3273222504930008','obt005','197304252000031008','000004',3);
  174. INSERT INTO Membeli VALUES('3273220505940009','obt009','197405052000031009','000005',4);
  175. INSERT INTO Membeli VALUES('3273220505940009','obt010','197405052000031009','000005',4);
  176. INSERT INTO Membeli VALUES('3273220606950011','obt006','197506062000031011','000006',1);
  177. INSERT INTO Membeli VALUES('3273220606950011','obt002','197506062000031011','000006',2);
  178. INSERT INTO Membeli VALUES('3273220606950011','obt004','197506062000031011','000006',5);
  179. INSERT INTO Membeli VALUES('3273222207960014','obt014','197607222000031014','000007',3);
  180. INSERT INTO Membeli VALUES('3273222207960014','obt003','197607222000031014','000007',3);
  181. INSERT INTO Membeli VALUES('3273222108970016','obt016','197708232000032016','000008',6);
  182. INSERT INTO Membeli VALUES('3273220909980017','obt009','197809092000032017','000009',5);
  183. INSERT INTO Membeli VALUES('3273220909980017','obt004','197809092000032017','000009',4);
  184. INSERT INTO Membeli VALUES('3273221011990019','obt005','197911212000031019','000010',3);
  185. INSERT INTO Membeli VALUES('3273221011990019','obt020','197911212000031019','000010',1);
  186.  
  187. INSERT INTO Menyuplai VALUES('obt001','sp001','000001');
  188. INSERT INTO Menyuplai VALUES('obt002','sp001','000002');
  189. INSERT INTO Menyuplai VALUES('obt003','sp001','000003');
  190. INSERT INTO Menyuplai VALUES('obt004','sp002','000004');
  191. INSERT INTO Menyuplai VALUES('obt005','sp003','000005');
  192. INSERT INTO Menyuplai VALUES('obt004','sp004','000006');
  193. INSERT INTO Menyuplai VALUES('obt003','sp004','000007');
  194. INSERT INTO Menyuplai VALUES('obt002','sp004','000008');
  195. INSERT INTO Menyuplai VALUES('obt001','sp004','000009');
  196. INSERT INTO Menyuplai VALUES('obt010','sp011','000010');
  197. INSERT INTO Menyuplai VALUES('obt011','sp011','000011');
  198. INSERT INTO Menyuplai VALUES('obt001','sp012','000012');
  199. INSERT INTO Menyuplai VALUES('obt013','sp013','000013');
  200. INSERT INTO Menyuplai VALUES('obt014','sp013','000014');
  201. INSERT INTO Menyuplai VALUES('obt015','sp015','000015');
  202. INSERT INTO Menyuplai VALUES('obt001','sp016','000016');
  203. INSERT INTO Menyuplai VALUES('obt017','sp019','000017');
  204. INSERT INTO Menyuplai VALUES('obt018','sp019','000018');
  205. INSERT INTO Menyuplai VALUES('obt001','sp019','000019');
  206. INSERT INTO Menyuplai VALUES('obt020','sp020','000020');
  207.  
  208. INSERT INTO Stock_keeper VALUES('Mamat','Jl Perumahan Buah Batu No. 4','197001012000031021','L','087764117865','01-01-1970','000010');
  209. INSERT INTO Stock_keeper VALUES('Junaedi','Jl. Cherry Field No. 4','197001282000031022','L','087764117866','28-01-1970','000002');
  210. INSERT INTO Stock_keeper VALUES('Slamet','Jl. PGA N0. 4','197102022000031023','L','087764117867','02-02-1971','000008');
  211. INSERT INTO Stock_keeper VALUES('Juminten','Jl. Sukabirus N0. 4','197102272000032024','P','087764117868','27-02-1971','000006');
  212. INSERT INTO Stock_keeper VALUES('Euis','Jl. Sukapura No. 4','197203032000032025','P','087764117869','03-03-1972','000006');
  213. INSERT INTO Stock_keeper VALUES('Dadang','Jl. Pesona Bali Residence No. 4','197203262000031026','L','087764117870','26-03-1972','000003');
  214. INSERT INTO Stock_keeper VALUES('Maman','Jl. Gelora Bandung Asri N0. 4','197304042000031027','L','087764117871','04-04-1973','000001');
  215. INSERT INTO Stock_keeper VALUES('Neneng','Jl Perumahan Buah Batu No. 5','197304252000032028','P','087764117872','25-04-1973','000009');
  216. INSERT INTO Stock_keeper VALUES('Ita','Jl. Cherry Field No. 5','197405052000032029','P','087764117873','05-05-1974','000004');
  217. INSERT INTO Stock_keeper VALUES('Susanti','Jl. PGA N0. 5','197405242000032030','P','087764117874','24-05-1974','000009');
  218. INSERT INTO Stock_keeper VALUES('Asih','Jl. Sukabirus N0. 5','197506062000032031','P','087764117875','06-06-1975','000005');
  219. INSERT INTO Stock_keeper VALUES('Susi','Jl. Sukapura No. 5','197506232000032032','P','087764117876','23-06-1975','000007');
  220. INSERT INTO Stock_keeper VALUES('Bambang','Jl. Pesona Bali Residence No. 5','197607072000031033','L','087764117877','07-07-1976','000007');
  221. INSERT INTO Stock_keeper VALUES('Lastri','Jl. Gelora Bandung Asri N0. 5','197607222000032034','P','087764117878','22-07-1976','000002');
  222. INSERT INTO Stock_keeper VALUES('Sri','Jl Perumahan Buah Batu No. 6','197708082000032035','P','087764117879','08-08-1977','000004');
  223. INSERT INTO Stock_keeper VALUES('Mulyani','Jl. Cherry Field No. 6','197708232000032036','P','087764117880','23-08-1977','000003');
  224. INSERT INTO Stock_keeper VALUES('Sulastir','Jl. PGA N0. 6','197809092000032037','P','087764117881','09-09-1978','000011');
  225. INSERT INTO Stock_keeper VALUES('Margono','Jl. Sukabirus N0. 6','197810222000031038','L','087764117882','22-10-1978','000001');
  226. INSERT INTO Stock_keeper VALUES('Mamik','Jl. Sukapura No. 6','197911212000032039','P','087764117883','21-11-1979','000005');
  227. INSERT INTO Stock_keeper VALUES('Suginah','Jl. Pesona Bali Residence No. 6','198012302000032040','P','087764117884','30-12-1980','000008');
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!