scripts/LJCOPY/smart_update/LOG_SMART.sql

column dcol new_value SYSDATE noprint
select to_char(sysdate,'DDMMYY_HH24MI') dcol from dual;

--spool /home/oracle/LJ/smart_update/log/PRSMAM_UPDATE'date +%d%m%YT%H%M%S'.txt
spool /home/oracle/LJ/smart_update/log/PRSMAM_UPDATE_&sysdate.txt
select /*csv*/SP_ID,CHAR_TYPE_CD,CHAR_VAL,EFFDT FROM CCBADM.MV_P2_MAM;


--spool /home/oracle/LJ/smart_update/log/PRSMAM_UPDATE'date +%d%m%YT%H%M%S'.txt
spool /home/oracle/LJ/smart_update/log/APPTMOP_UPDATE_&sysdate.txt
select /*csv*/SP_ID,CHAR_TYPE_CD,CHAR_VAL,EFFDT FROM CCBADM.MV_P2_MO;

spool off;
exit