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

Oracle:

Declare

V_num number (8): = 0

BEGIN

FOR i IN (select id from T_BRAND) LOOP

Delete from T_BRAND de where de.id = i.ID

V_num: = v_num+1

If v_num > = 500

Then

V_num: = 1

Commit

End if

END LOOP

END

Mongo:

For (iSuppli)

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.