How to get date modified from script on CMD

I want to get all php files from existing folder, and the script is:
For example:
forfiles /M *.php /C “cmd /c echo @file;@fdate @ftime” >> list_source.csv

notes:
If you wan’t to replace the list_source.csv, before you run the script, ensure the list_source.csv is not on the directory

How to “grant user” automatically

— grant and synonym to umenu
DECLARE
BEGIN
BEGIN
FOR i IN (
SELECT ‘CREATE SYNONYM umenu.’||object_name||’ FOR retuser.’||object_name sql_stat
FROM user_objects
WHERE object_type IN (‘TABLE’,’FUNCTION’,’PROCEDURE’,’PACKAGE’,’TYPE’,’SEQUENCE’)–(‘SYNONYM’,’INDEX’,’TRIGGER’,’PACKAGE BODY’,’TYPE BODY’)
AND object_name NOT IN (
SELECT table_name FROM user_nested_tables)
ORDER BY object_type, object_name) LOOP
EXECUTE IMMEDIATE i.sql_stat;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
FOR i IN (
SELECT DECODE(object_type,
‘TABLE’,’GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON ‘||object_name||’ TO umenu’,
‘SEQUENCE’,’GRANT SELECT, ALTER ON ‘||object_name||’ TO umenu’,
‘GRANT EXECUTE ON ‘||object_name||’ TO umenu’) sql_stat
FROM user_objects
WHERE object_type IN (‘TABLE’,’FUNCTION’,’PROCEDURE’,’PACKAGE’,’TYPE’,’SEQUENCE’)–(‘SYNONYM’,’INDEX’,’TRIGGER’,’PACKAGE BODY’,’TYPE BODY’)
AND object_name NOT IN (
SELECT table_name FROM user_nested_tables)
ORDER BY object_type, object_name) LOOP
EXECUTE IMMEDIATE i.sql_stat;
END LOOP;
END;
/

CACLS add security using cmd

example: cacls *.* /e /p hostname\ORA_OraDB12Home1_DBA:F

example: cacls *.* /e /p hostname\everyone:F

How to Import (IMPDP) with replace some tables

impdp dbadmin/passwordnya@DBLINK parfile=parfilename.par

—this is parfilename.par

DUMPFILE=DATA_PUMP_DIR:DATA_SEMUA_USER_30042021SBB_%U.dmp
PARALLEL=6
TABLE_EXISTS_ACTION=REPLACE
TABLES=(‘DBADMIN.LN_ECL’,’DBADMIN.LN_MASTER’,’DBADMIN.LN_MASTER02′,’DBADMIN.LN_MASTER_ECL’, ‘DBADMIN.LN_JADUAL_ANGS’,’DBADMIN.LN_JADUAL_ANGS_EIR’, ‘DBADMIN.LN_STAT_PPA71′,’DBADMIN.LN_POS_SALDO_ECL’,’DBADMIN.LN_POS_SALDO_ECL_HIST’, ‘DBADMIN.LN_RE_JADUAL_ANGS’,’DBADMIN.DD_MASTER’,’DBADMIN.DD_MASTER_BAS2′, ‘DBADMIN.DD_TAGIHAN’,’DBADMIN.DD_MASTER03′)

Query to get previous data for several years

I’ve 3 categories to show data from loan master,
1. Date opening loan range 3 until 5 years
2. Date opening loan range 5 until 10 years
3. Date opening loan > 10 years

This is the script to show all data:

select 'PRODUK 604 range 3 s/d 5 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val,no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit 
from ln_master 
where kd_produk=6 and kd_sub_produk=4 and kd_val=0 and tgl_akad_kredit < trunc(add_months(sysdate,-(3*12))) and tgl_akad_kredit =trunc(add_months(sysdate,-(5*12))) 
union 
select 'PRODUK 604 range 5 s/d 10 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val,no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit 
from ln_master 
where kd_produk=6 and kd_sub_produk=4 and kd_val=0 and tgl_akad_kredit < trunc(add_months(sysdate,-(5*12))) and tgl_akad_kredit =trunc(add_months(sysdate,-(10*12)))
union
select 'PRODUK 604 range > 10 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val, no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit
from ln_master
where kd_produk=6 and kd_sub_produk=4 and kd_val=0
and tgl_akad_kredit < trunc(add_months(sysdate,-(10*12)));

Script to generate DDL from all schema except sys, system, etc.

set heading off;
set echo off;
Set pages 1000;
set long 50000;
SET linesize 150;
spool d:\exec_Myddl.sql;
select 'set heading off; set echo off;Set pages 1000;set long 50000; SET linesize 150; spool d:\My_ddl.sql;' from dual;
select 'select DBMS_METADATA.GET_DDL(''TABLE'','''||table_name||''','''||owner||''') from dual;' from all_tables
where owner not in ('SYS','SYSTEM','SYSMAN','DBSNMP','OUTLN','MDSYS','ORDDATA','APPQOSSYS','GSMADMIN_INTERNAL','XDB',
'DBSFWUSER','WMSYS','OJVMSYS','CTXSYS','LBACSYS','OLAPSYS','LBACSYS','DVSYS','HR','DEV_WLS','DEV_OPSS',
'DEV_IAU','DEV_STB','SCOTT','DEV_WLS_RUNTIME','ORDSYS');
select 'spool off;' from dual;
spool off;
@d:\exec_myddl.sql;
/

— NOTE: The exec_mydll.sql file is automate to generate script DDL, and the result is my_ddl.sql

How to disable second hard disk on VMWARE

Problem: The file (vmdk) from the second hard drive was accidentally deleted

I’ve tried to troubleshoot with open vmx files, There’s two scsi
First, scsi0:0
Second, scsi0:1

1. Change
scsi0:1.present = “TRUE“
with
scsi0:1.present = “FALSE“

How to kill Anydesk (full screen with keyboard locked) ~ Windows

Sometimes I’m using anydesk with fullscreen mode, and keyboard locking with another application happened, I tried to kill anydesk with task manager or kill manually on the task bar is useless. Then I try to another way to kill anydesk, with CMD run as administrator, and it works.

Follow this instruction to solve the problem.

Run as administrator on CMD

On CMD
type taskkill /IM anydesk.exe
if not success then taskkill /IM anydesk.exe /F

How to unlock weblogic

–Erase lok file ~ Hapus file lok

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/tmp
rm *.lok

–Erase inside ldap folder ~ hapus file didalam folder ldap

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/data
rm -rf ldap/

–find Middle id (like search in task manager on windows) ~ cari id Middle

ps -ef | grep Middle

kill -9

–start weblogic

sh /home/oracle/Middleware/user_projects/domains/<domain_name>/bin/startWebLogic.sh

Pengalaman Mengurus Roya di Kantor BPN Tangerang Selatan (September 2015)

Tahukah anda bahwa Kantor BPN Kota Tangerang Selatan buka di hari Sabtu dan Minggu? 🙂 🙂 🙂

Ya! Pelayanan akhir pekan ini memang khusus ditujukan bagi Masyarakat umum. Secara umum, Pelayanan terbagi menjadi 2 yaitu :
1. Pendaftaran dan Pemrosesan dokumen – dari jam 09.00 s.d. 11.00
2. Penyerahan Produk / Sertifikat yang telah di proses – dari jam 12.00 s.d. 13.00

Belum lama ini saya datang ke BPN Kota TangSel untuk mengurus Penghapusan Hak Tanggungan terhadap Sertifikat Tanah/Rumah yang saya miliki, atau lebih dikenal dengan istilah Roya. Proses administrasi ini diperlukan untuk membuktikan bahwa kita sebagai Pemilik Tanah/Rumah sudah tidak lagi memiliki hutang dengan Bank, tentunya karena kita telah menyelesaikan pelunasan kredit pinjaman tersebut.

Adapun syarat-syarat yang diperlukan sbb:

Nah – semua informasi persyaratan dapat dengan mudah diperoleh dari Brosur resmi BPN yang tersedia di kantor tersebut.

Secara garis besar ada 3 “ruangan” yang perlu kita kunjungi. Pertama adalah…

View original post 488 more words