SELECT T.EXTSHAPE_CD ,T.MIAN_DESC ,T.CE_DESC ,T.TOU_DESC ,T.DAXIAO_DESC ,T.DUOSHAO_DESC ,T.SHOUGAN_DESC ,T.SHIJUE_DESC ,T.QITA_DESC ,T.RMK_DESC ,T.REG_ID ,T.REG_DTIME ,T.MOD_ID ,T.MOD_DTIME ,T.EXTSHAPE_CD EXTSHAPE_CD_1 FROM TBB01_SEQ_EXTSHAPE T ORDER BY T.EXTSHAPE_CD UPDATE TBB01_SEQ_EXTSHAPE SET EXTSHAPE_CD = ? ,MIAN_DESC = ? ,CE_DESC = ? ,TOU_DESC = ? ,DAXIAO_DESC = ? ,DUOSHAO_DESC = ? ,SHOUGAN_DESC = ? ,SHIJUE_DESC = ? ,QITA_DESC = ? ,RMK_DESC = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE EXTSHAPE_CD = ? INSERT INTO TBB01_SEQ_EXTSHAPE (EXTSHAPE_CD ,MIAN_DESC ,CE_DESC ,TOU_DESC ,DAXIAO_DESC ,DUOSHAO_DESC ,SHOUGAN_DESC ,SHIJUE_DESC ,QITA_DESC ,RMK_DESC ,REG_ID ,REG_DTIME ) VALUES (?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) DELETE FROM TBB01_SEQ_EXTSHAPE WHERE EXTSHAPE_CD = ?