INSERT INTO GCM_SORYO (MISE_CD, BUMON_CD, TEI_ZOKU, HAISO_CHIKU_CD, MOS_CART_CD, SORYO, KINSHI_FLG, INS_YMD, INS_HMS, LST_UPDTS, UPDT_KAI, LST_UPDT_YMD, LST_UPDT_HMS "SELECT
'1111' MISE_CD,
'000' BUMON_CD, GCM_SORYO.TEI_ZOKU, GCM_SORYO.HAISO_CHIKU_CD, GCM_SORYO.MOS_CART_CD, GCM_SORYO.SORYO, GCM_SORYO.KINSHI_FLG, TO_CHAR (SYSDATE, 'YYYYMMDD') INS_YMD, TO_CHAR (SYSDATE, 'HH24MISS') INS_HMS, 00369 LST_UPDTS,
1 UPDT_KAI, TO_CHAR (SYSDATE, 'YYYYMMDD') LST_UPDT_YMD, TO_UPDT_YMD, TO_CHAR (SYSDATE, 'HH24MISS') LST_UPDT_HMS from GCM_SORYO Where GCM_SORYO.MISE_CD = 1111 and gcm_soryo.bumon_cd = 111
In front of the SELECT field plus a fixed value, it is equivalent to assigning this column, which uses this same value, no comma between the values, and fields.
