| 123456789101112131415161718192021222324252627282930 |
- 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_MO;
- commit;
|
