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

0 rows created.

Elapsed: 00:00:00.01
10:28:17 SQL> 
10:28:17 SQL> spool off