updatedibook_kiki

select * from reggd select * from desa where desaid=’230B32B5CE944A5AE040A8C003001C9F’ select * from berkas where berkasnomor=’4492′ and berkasyear=2007 select * from dibook where berkasid=’c2fd397c632545e5925c1e573b3d7ec0′ select * from berkasprosedur select count(*), berkasidfrom berkasprosedur where prosedurcode=’31′ and prosedurorder=1group by berkasidhaving count(*) = 1 select * from dibookwhere exists (select 1from berkasprosedur where prosedurcode=’31′ and prosedurorder=1and berkasprosedur.berkasid=dibook.berkasidgroup by [...]

tekstual – updateemployee

update dibook set ditanggal = ’01/05/2007′where berkasid = ’09b2cc496cf64d7d9549d19e5d153217′and prosedurcode = ’62′and identseq = ‘de63e04785c743428b3fc2b36766dc6e’; commit;

tekstual – updateditanggal

– ditanggal = MM/DD/YYYY update dibook set ditanggal = ’12/21/2006′where berkasid = ‘b7b8e7a56fa643d7b2ed284b9cf616b9′and prosedurcode = ’06′and identseq = ‘d42b0cd2381841448b3f177dc1d4b6f5′; commit; – sebelum menjalankan update tanggal DI, jalankan tekstual-cari nomor DI & berkas– untuk mendapatkan identseq, seperti dibawah ini :– select dibook.* from dibook,berkas– where dibook.berkasid = berkas.berkasid– and berkas.berkasnomor = ’260′– and dibook.dikode = ‘DI307′;

tekstual – update_kode prosedur

update dibook set prosedurcode = ’31′where berkasid = ‘a0cb7ffb5f264ef2bc7e148e17f5c098′and identseq = ’28538E431F2BD956E040A8C001015105′; commit;

select * from reggd select * from desa where desaid=’230B32B5CE944A5AE040A8C003001C9F’ select * from berkas where berkasnomor=’4492′ and berkasyear=2007 select * from dibook where berkasid=’c2fd397c632545e5925c1e573b3d7ec0′ select * from berkasprosedur select count(*), berkasidfrom berkasprosedur where prosedurcode=’31′ and prosedurorder=1group by berkasidhaving count(*) = 1 select * from dibookwhere exists (select 1from berkasprosedur where prosedurcode=’31′ and prosedurorder=1and berkasprosedur.berkasid=dibook.berkasidgroup by [...]

select * from reggd select * from desa where desaid=’230B32B5CE944A5AE040A8C003001C9F’ select * from berkas where berkasnomor=’4492′ and berkasyear=2007 select * from dibook where berkasid=’c2fd397c632545e5925c1e573b3d7ec0′ select * from berkasprosedur select count(*), berkasidfrom berkasprosedur where prosedurcode=’31′ and prosedurorder=1group by berkasidhaving count(*) = 1 select * from dibookwhere exists (select 1from berkasprosedur where prosedurcode=’31′ and prosedurorder=1and berkasprosedur.berkasid=dibook.berkasidgroup by [...]

select * from reggd select * from desa where desaid=’230B32B5CE944A5AE040A8C003001C9F’ select * from berkas where berkasnomor=’4492′ and berkasyear=2007 select * from dibook where berkasid=’c2fd397c632545e5925c1e573b3d7ec0′ select * from berkasprosedur select count(*), berkasidfrom berkasprosedur where prosedurcode=’31′ and prosedurorder=1group by berkasidhaving count(*) = 1 select * from dibookwhere exists (select 1from berkasprosedur where prosedurcode=’31′ and prosedurorder=1and berkasprosedur.berkasid=dibook.berkasidgroup by [...]

select * from reggd select * from desa where desaid=’230B32B5CE944A5AE040A8C003001C9F’ select * from berkas where berkasnomor=’4492′ and berkasyear=2007 select * from dibook where berkasid=’c2fd397c632545e5925c1e573b3d7ec0′ select * from berkasprosedur select count(*), berkasidfrom berkasprosedur where prosedurcode=’31′ and prosedurorder=1group by berkasidhaving count(*) = 1 select * from dibookwhere exists (select 1from berkasprosedur where prosedurcode=’31′ and prosedurorder=1and berkasprosedur.berkasid=dibook.berkasidgroup by [...]

tekstual – query insert dibook_rev

insert into dibook values (sys_guid(),’DI208′,’2007′,(select to_char(max(to_number(dinomor))+1) from dibook where ditahun =’2006′ and dikode =’DI208′),to_date(’25/12/2006′,’DD/MM/YYYY’),’E’, (select berkasid from berkas where berkasnomor =’785′ and berkasyear =’2006′),’06′,’750003469′,’A304′,’P’,’1′,’178bd91f09e54c44bb68bf623379dc13′,’N’,null,null);–’prosedur’,’NIP BKP’,’seksikode’,’(P)dari prosedur’,’1′aktif,kode kantor,’N’,null…. commit;

tekstual – nomor hak dapat digunakan utk beberapa berkas

select * from profileorder by keterangan ; select rh.regid from reghat rh, desa dwhere d.desaid = rh.desaid– kondisi desa menggunakan kode desa– and d.desaco8 = ’09010101′– kondisi desa menggunakan nama desa and d.desanama like ‘%Duri Pulo%’ and rh.tipehakid = ’3′ and rh.nomor = ’2532′; – Hapus berkasidlock di tabel registerselect * from registerwhere berkasid = [...]