Script Update Flag Status = 1 dimana NIK ada di CAPIL_MATI

Script dari Group ADB Nasional oleh Bapak ADB Nasional Ir. Mhd. Saleh Sitompul
--update flag_status=1 dmn NIK sdh ada capil_mati

SELECT *
FROM (SELECT
row_number() over (partition by mati_nik order by mati_nik,
adm_akta_no desc) no, to_char(nik)nik_bio, to_char(mati_nik)nik_mati, a.flag_status,
'update biodata_wni set flag_status=''1'||''' where nik='||nik||';' update_flag_status_biodata
FROM BIODATA_WNI a join CAPIL_MATI b on to_char(a.nik)=to_char(b.mati_nik)
where a.flag_status<>'1'
 )
WHERE no=1;

Semoga Bermanfaat,

Subscribe to receive free email updates:

0 Response to "Script Update Flag Status = 1 dimana NIK ada di CAPIL_MATI"

Posting Komentar