10:26:10 SQL> INSERT INTO CCBADM.CI_SP_CHAR (
10:26:10   2  SP_ID,
10:26:10   3  CHAR_TYPE_CD,
10:26:10   4  CHAR_VAL,
10:26:10   5  EFFDT,
10:26:10   6  VERSION,
10:26:10   7  ADHOC_CHAR_VAL,
10:26:10   8  CHAR_VAL_FK1,
10:26:10   9  CHAR_VAL_FK2,
10:26:10  10  CHAR_VAL_FK3,
10:26:10  11  CHAR_VAL_FK4,
10:26:10  12  CHAR_VAL_FK5,
10:26:10  13  SRCH_CHAR_VAL)
10:26:10  14  SELECT
10:26:10  15  SP_ID,
10:26:10  16  CHAR_TYPE_CD,
10:26:10  17  CHAR_VAL,
10:26:10  18  to_date(EFFDT,'YYYY-MM-DD') EFFDT,
10:26:10  19  VERSION,
10:26:10  20  ADHOC_CHAR_VAL,
10:26:10  21  CHAR_VAL_FK1,
10:26:10  22  CHAR_VAL_FK2,
10:26:10  23  CHAR_VAL_FK3,
10:26:10  24  CHAR_VAL_FK4,
10:26:10  25  CHAR_VAL_FK5,
10:26:10  26  SRCH_CHAR_VAL
10:26:10  27  FROM CCBADM.MV_P2_MAM;

14 rows created.

Elapsed: 00:00:00.01
10:26:10 SQL> 
10:26:10 SQL> spool off