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