scripts/LJCOPY/smart_update/PRSMAM_UPDATE.sql

spool "/home/oracle/LJ/smart_update/PRSMAM_UPDATE.txt"
INSERT INTO CCBADM.CI_SP_CHAR (
SP_ID,
CHAR_TYPE_CD,
CHAR_VAL,
EFFDT,
VERSION,
ADHOC_CHAR_VAL,
CHAR_VAL_FK1,
CHAR_VAL_FK2,
CHAR_VAL_FK3,
CHAR_VAL_FK4,
CHAR_VAL_FK5,
SRCH_CHAR_VAL)
SELECT 
SP_ID,
CHAR_TYPE_CD,
CHAR_VAL,
to_date(EFFDT,'YYYY-MM-DD') EFFDT,
VERSION,
ADHOC_CHAR_VAL,
CHAR_VAL_FK1,
CHAR_VAL_FK2,
CHAR_VAL_FK3,
CHAR_VAL_FK4,
CHAR_VAL_FK5,
SRCH_CHAR_VAL
FROM CCBADM.MV_P2_MAM;

spool off

commit;