Oracle使用虚拟表dual一次插入多条记录(三)
,var_TMPSupplier20Rate
,var_TMPSupplier20DialCode
,var_TMPSupplier21ID
,var_TMPSupplier21Rate
,var_TMPSupplier21DialCode
,var_TMPSupplier22ID
,var_TMPSupplier22Rate
,var_TMPSupplier22DialCode
,var_TMPSupplier23ID
,var_TMPSupplier23Rate
,var_TMPSupplier23DialCode
,var_TMPSupplier24ID
,var_TMPSupplier24Rate
,var_TMPSupplier24DialCode
,var_TMPSupplier25ID
,var_TMPSupplier25Rate
,var_TMPSupplier25DialCode
,var_TMPSupplier26ID
,var_TMPSupplier26Rate
,var_TMPSupplier26DialCode
,var_TMPSupplier27ID
,var_TMPSupplier27Rate
,var_TMPSupplier27DialCode
,var_TMPSupplier28ID
,var_TMPSupplier28Rate
,var_TMPSupplier28DialCode
,var_TMPSupplier29ID
,var_TMPSupplier29Rate
,var_TMPSupplier29DialCode
,var_TMPSupplier30ID
,var_TMPSupplier30Rate
,var_TMPSupplier30DialCode ;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;