oracle 插入的时候 子查询

mybatis写法如下:

<insert id="insert1" parameterType="com.model.table1 ">
        insert into table1 (clumn1, clumn2, TRACE_NO,
        TRACE_TIME, SETTLE_DATE, SETTLE_CURRENCY_CODE,
        SETTLE_AMT,SETTLE_YEAR)
        values (#{clumn1,jdbcType=VARCHAR}, #{clumn2,jdbcType=VARCHAR}, 
                #{traceNo,jdbcType=VARCHAR},
            #{traceTime,jdbcType=VARCHAR}, 
            #{settleDate,jdbcType=VARCHAR}, 
            #{settleCurrencyCode,jdbcType=VARCHAR},
            #{settleAmt,jdbcType=DECIMAL},
        (select 
           case
               when to_date(to_char(sysdate,'yyyy')||'0112','yyyyMMdd')>sysdate 
               then to_char(sysdate-12,'yyyy')
           else to_char(sysdate,'yyyy')
           end from dual)
        )
    </insert>

记录一下