Advertisement
yoshoo

Untitled

Aug 19th, 2019
1,358
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE kategori_simpanan
  2. (kode_kategori_simpanan CHAR(10) PRIMARY KEY,
  3. nama_kategori_simpanan VARCHAR2(30) NOT NULL,
  4. nominal int);
  5. DESC kategori_simpanan;
  6.  
  7. INSERT INTO kategori_simpanan values  ('KS001','Pokok','500000');
  8. INSERT INTO kategori_simpanan values  ('KS002','Wajib','300000');
  9. INSERT INTO kategori_simpanan values  ('KS003','Sukarela','100000');
  10. SELECT * FROM kategori_simpanan;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement