INSERT INTO GEC_STRATEGY_PROFILE sm ( sm.STRATEGY_ID, sm.STRATEGY_PROFILE_ID, sm.TRADE_COUNTRY_CD, sm.SB_PERCENTAGE, sm.SB_RAL_PERCENTAGE, sm.SFA_PERCENTAGE, sm.SURROGATE_PERCENTAGE, sm.EXT2_PERCENTAGE, sm.SB_RATE, sm.NSB_RATE, sm.MIN_SP_RATE, sm.GC_RATE, sm.STATUS, sm.COLLATERAL_CURRENCY_CD, sm.COLLATERAL_TYPE, sm.HOLDBACK_FLAG, sm.SCHEDULED_AT, sm.AVAILABILITY_REGIONS_STR ) VALUES ( #strategyId:NUMERIC#, #strategyMarketId:NUMERIC#, #tradeCountry:VARCHAR#, #sbPercentage:NUMBER#/100, #sbRalPercentage:NUMBER#/100, #sfaPercentage:NUMBER#/100, #surrogatePercentage:NUMBER#/100, #ext2Percentage:NUMBER#/100, #sbRate:NUMBER#, #nsbRate:NUMBER#, #minSpRate:NUMERIC#, #gcRate:NUMERIC#, #profileStatus:VARCHAR#, #collCode:VARCHAR#, #collType:VARCHAR#, #holdBackFlag:VARCHAR#, #scheduleAt:VARCHAR#, #availRegion:VARCHAR# )
注意以上的NUMBER和NUMERIC,NUMERIC 可以给NULL,但NUMBER如果是NULL的话会报错:invalid column type