| 123456789101112131415161718192021222324252627282930313233 |
- 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
|
