CREATE TABLE petugas
(kode_petugas CHAR(10) PRIMARY KEY,
nama_petugas VARCHAR2(30) NOT NULL,
kode_jabatan CHAR(10), CONSTRAINT fk_petugas_jabatan foreign KEY(kode_jabatan)
references jabatan(kode_jabatan) ON DELETE CASCADE,
email VARCHAR2(50) UNIQUE,
no_telepon NUMBER(15) UNIQUE);

INSERT INTO petugas VALUES ('KP001','Sugiyanto','KJ001','sugiyanto@gmail.com','082712637212');
INSERT INTO petugas VALUES ('KP002','Suharto','KJ002','suharto@gmail.com','081274827126');
INSERT INTO petugas VALUES ('KP003','Said','KJ003','said@gmail.com','087261236462');
SELECT * FROM petugas;