Insert DI 312C

select max(to_number(dinomor)) from dibook
where dikode='DI312C' and ditahun=2007;

select * from dibook
where dikode='DI301' and ditahun=2006 and dinomor=18038;

--insert into dibook
--values(sys_guid(),'DI312C','2006',2570,to_date('20/12/2006','dd-mm-yyyy'),
--'E','ad0987f65553475d8201be70fb7d56c5','06','750005343','4003','P','1',
--'734bfde7273040cd8efbc6d856446d2f','N',null,null);

select * from dibook
where dikode='DI312C' and ditahun=2007 and dinomor = 2531;
--delete from dibook
--where dikode='DI312C' and ditahun=2007 and dinomor=1559;