Shulou(Shulou.com)06/01 Report--

CREATE OR REPLACE PROCEDURE pubres_test

As

BEGIN

For obj in (

Select resource_name,unit_name,resource_code,sum (update_count) update_count

From winf_pubres_update_log

Group by resource_name,unit_name,resource_code)

Loop

-- Statistical summary

Insert into WINF_PUBRES_allUPDATE_LOG (unit_name,resource_name,resource_code,update_count,update_date)

Values (obj.unit_name,obj.resource_name,obj.resource_code,to_char (obj.update_count), sysdate)

End loop

END pubres_test

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.