Oracle使用虚拟表dual一次插入多条记录(二)
DialCode from dual
union all select :var_TMPSupplier29ID,:var_TMPSupplier29Rate,:var_TMPSupplier29DialCode from dual
union all select :var_TMPSupplier30ID,:var_TMPSupplier30Rate,:var_TMPSupplier30DialCode from dual'
using var_TMPSupplier1ID
,var_TMPSupplier1Rate
,var_TMPSupplier1DialCode
,var_TMPSupplier2ID
,var_TMPSupplier2Rate
,var_TMPSupplier2DialCode
,var_TMPSupplier3ID
,var_TMPSupplier3Rate
,var_TMPSupplier3DialCode
,var_TMPSupplier4ID
,var_TMPSupplier4Rate
,var_TMPSupplier4DialCode
,var_TMPSupplier5ID
,var_TMPSupplier5Rate
,var_TMPSupplier5DialCode
,var_TMPSupplier6ID
,var_TMPSupplier6Rate
,var_TMPSupplier6DialCode
,var_TMPSupplier7ID
,var_TMPSupplier7Rate
,var_TMPSupplier7DialCode
,var_TMPSupplier8ID
,var_TMPSupplier8Rate
,var_TMPSupplier8DialCode
,var_TMPSupplier9ID
,var_TMPSupplier9Rate
,var_TMPSupplier9DialCode
,var_TMPSupplier10ID
,var_TMPSupplier10DialCode
,var_TMPSupplier11ID
,var_TMPSupplier11Rate
,var_TMPSupplier11DialCode
,var_TMPSupplier12ID
,var_TMPSupplier12Rate
,var_TMPSupplier12DialCode
,var_TMPSupplier13ID
,var_TMPSupplier13Rate
,var_TMPSupplier13DialCode
,var_TMPSupplier14ID
,var_TMPSupplier14Rate
,var_TMPSupplier14DialCode
,var_TMPSupplier15ID
,var_TMPSupplier15Rate
,var_TMPSupplier15DialCode
,var_TMPSupplier16ID
,var_TMPSupplier16Rate
,var_TMPSupplier16DialCode
,var_TMPSupplier17ID
,var_TMPSupplier17Rate
,var_TMPSupplier17DialCode
,var_TMPSupplier18ID
,var_TMPSupplier18Rate
,var_TMPSupplier18DialCode
,var_TMPSupplier19ID
,var_TMPSupplier19Rate
,var_TMPSupplier19DialCode
,var_TMPSupplier20ID