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