Insert data to tables on oracle db

apotekdataoracle.sql

INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0001','Adam Raki','Teritip','L','20','082255150');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0002','Hanna Montana','Kampung Baru Ujung','P','24','058822402');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0003','Miley Cyrus','Gunung Bakaran','P','29','085521251');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0004','Taylor Swift','Lamaru','P','26','082151561');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0005','Charlie Puth','Gunung Bubukan Atas','L','23','081215100');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0006','Bill Gates','Martadinata','L','65','082564512');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0007','John Scott','BDS 1','L','32','098123156');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0008','Michael Solely','Gunung Guntur','L','41','085214522');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0009','Scott Hanselman','Beler Atas','L','40','081213215');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0010','Kleeman','PJHI Batakan','L','35','081215314');

select * from pelanggan;

INSERT INTO Penyakit VALUES('PK1','Tipes','Panas dingin, demam tinggi, Muka pucat');
INSERT INTO Penyakit VALUES('PK2','DBD','Panas Dingin, Demam tinggi, Pusing, Mual, Bintik-Bintik Merah');
INSERT INTO Penyakit VALUES('PK3','Cacar Air','Panas, Mual, Ruam Kulit, Pusing');
INSERT INTO Penyakit VALUES('PK4','Batu Ginjal','Sakit perut di sisi kanan, sakit pinggang');
INSERT INTO Penyakit VALUES('PK5','Diabetes','Sering Ngantuk, Pusing, Sakit perut, Gula darah tinggi');

select * from penyakit;

INSERT INTO Jenis VALUES('J1','tablet');
INSERT INTO Jenis VALUES('J2','sirup');
INSERT INTO Jenis VALUES('J3','kapsul');
INSERT INTO Jenis VALUES('J4','cair');
INSERT INTO Jenis VALUES('J5','bubuk');
INSERT INTO Jenis VALUES('J6','salep');
INSERT INTO Jenis VALUES('J7','semprot');
INSERT INTO Jenis VALUES('J8','cream');

select * from Jenis;

-------------------------------------------------------------------------------------
--Input data penyakit
INSERT INTO Penyakit VALUES('PK1','Tipes','Panas dingin, demam tinggi, Muka pucat');
INSERT INTO Penyakit VALUES('PK2','DBD','Panas Dingin, Demam tinggi, Pusing, Mual, Bintik-Bintik Merah');
INSERT INTO Penyakit VALUES('PK3','Cacar Air','Panas, Mual, Ruam Kulit, Pusing');
INSERT INTO Penyakit VALUES('PK4','Batu Ginjal','Sakit perut di sisi kanan, sakit pinggang');
INSERT INTO Penyakit VALUES('PK5','Diabetes','Sering Ngantuk, Pusing, Sakit perut, Gula darah tinggi');

--Input data pelanggan
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0001','Adam Raki','Teritip','L','20','082255150');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0002','Hanna Montana','Kampung Baru Ujung','P','24','058822402');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0003','Miley Cyrus','Gunung Bakaran','P','29','085521251');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0004','Taylor Swift','Lamaru','P','26','082151561');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0005','Charlie Puth','Gunung Bubukan Atas','L','23','081215100');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0006','Bill Gates','Martadinata','L','65','082564512');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0007','John Scott','BDS 1','L','32','098123156');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0008','Michael Solely','Gunung Guntur','L','41','085214522');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0009','Scott Hanselman','Beler Atas','L','40','081213215');
INSERT INTO Pelanggan(IdPel, NamaPel, Alamat, JenKel, Umur, NoHp) VALUES('P0010','Kleeman','PJHI Batakan','L','35','081215314');

--Input data jenis
INSERT INTO Jenis VALUES('J1','tablet');
INSERT INTO Jenis VALUES('J2','sirup');
INSERT INTO Jenis VALUES('J3','kapsul');
INSERT INTO Jenis VALUES('J4','cair');
INSERT INTO Jenis VALUES('J5','bubuk');
INSERT INTO Jenis VALUES('J6','salep');
INSERT INTO Jenis VALUES('J7','semprot');
INSERT INTO Jenis VALUES('J8','cream');

--Input data kasir
INSERT INTO kasir VALUES('1','Ganda','L','Pagi');
INSERT INTO kasir VALUES('2','Iqbal','L','Siang');

--Input data obat
INSERT INTO OBAT VALUES('OB001','J1','Paracetamol','4000','50','10-APR-19','09-APR-20','PK1');
INSERT INTO OBAT VALUES('OB002','J1','Paratusin','8000','50','10-APR-19','10-JAN-23','PK2');
INSERT INTO OBAT VALUES('OB003','J4','Fu-Fang','300000','50','10-APR-19','30-APR-22','PK2');
INSERT INTO OBAT VALUES('OB004','J1','Antibiotik','10000','50','10-APR-19','20-MAR-21','PK1');
INSERT INTO OBAT VALUES('OB005','J1','Ramipril','100000','50','10-APR-19','15-MAY-21','PK4');
INSERT INTO OBAT VALUES('OB006','J1','Captopril','100000','50','10-APR-19','01-JUN-22','PK5');
INSERT INTO OBAT VALUES('OB007','J1','Diabex','18000','50','10-APR-19','31-JUL-21','PK5');
INSERT INTO OBAT VALUES('OB008','J3','Penadol','3500','50','10-APR-19','11-AUG-22','PK5');
INSERT INTO OBAT VALUES('OB009','J3','Arsiklovi','35000','50','10-APR-19','10-SEP-24','PK3');
INSERT INTO OBAT VALUES('OB010','J1','Bodrex','4000','50','10-APR-19','19-OCT-22','PK5');

--Input data transaksi
INSERT INTO TRANSAKSI VALUES('0001','OB001','1','P0001',LOCALTIMESTAMP,'1');
INSERT INTO TRANSAKSI VALUES('0002','OB002','1','P0002','02-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('0003','OB003','2','P0003','01-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('0004','OB004','1','P0004','01-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('0005','OB005','2','P0005','04-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('0006','OB006','1','P0006','03-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('007','OB007','1','P0007','18-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('008','OB008','2','P0008','12-MAR-19','1');
INSERT INTO TRANSAKSI VALUES('0009','OB009','2','P0009','04-APR-19','1');
INSERT INTO TRANSAKSI VALUES('0010','OB010','1','P0010','25-APR-19','1');
INSERT INTO TRANSAKSI VALUES('0011','OB002','2','P0001','30-APR-19','1');