項(xiàng)目中遇到測試，需要造4500數(shù)據(jù)，而且需要分部門和日期，一個(gè)部門一天30條數(shù)據(jù)，剩下的鋪墊數(shù)據(jù)可以一個(gè)部門一天100w左右數(shù)據(jù)，這里，每次變換部門，日期，需要操作至少300次，想到用存儲(chǔ)過程寫一個(gè)函數(shù)進(jìn)行

首先，了解存儲(chǔ)過程的語法：

CREATE [ OR REPLACE ] FUNCTION
name( [ [argmode] [argname]argtype[ { DEFAULT | = }default_expr] [, …] ] )
[ RETURNSrettype
| RETURNS TABLE (column_namecolumn_type[, …] ) ]
{ LANGUAGElang_name
| WINDOW
| IMMUTABLE | STABLE | VOLATILE
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| COSTexecution_cost
| ROWSresult_rows
| SETconfiguration_parameter{ TOvalue| =value| FROM CURRENT }
| AS ‘definition’
| AS ‘obj_file’, ‘link_symbol’
} …
[ WITH (attribute[, …] ) ]
————————————————