Tugas PBD

1. create table produk(
IDproduk varchar(6),
NamaProduk varchar(15),
harga number(20),
TanggalExpire date,constraint pkl primary key(id_model));



2. insert into model values('M-101','Rofiah','45','01-05-88');
insert into model values('M-102','Sabariah','50',null);
insert into model values('M-103','Jamilah','47','26-07-86');




3. update model set berat_badan = '92' where ID_Model = 'M-102'



4. alter table Model add (tinggi_badan number (2));



5. alter table Model modify (tinggi_badan number (4));

6. alter table model drop column tinggi_badan;




7. delete from Model where nama_model = 'Sabariah';






8. select * from model;