使用Oracle存储过程向表中写入、更新和删除数据
发布时间:2020-12-12 15:18:25 所属栏目:百科 来源:网络整理
导读:写入数据 BEGIN FOR I IN 1 .. 10 LOOP INSERT INTO ss VALUES ("I","I","I"); COMMIT; sys.DBMS_LOCK.sleep (5); END LOOP;END;/ 说明:在写入过程中,有主键冲突,则在最后会提示。但非主键冲突的数据已经写入到表中。 更新数据 BEGIN FOR I IN 1 .. 10 LO
写入数据BEGIN FOR I IN 1 .. 10 LOOP INSERT INTO ss VALUES ("I","I","I"); COMMIT; sys.DBMS_LOCK.sleep (5); END LOOP; END; /
更新数据BEGIN FOR I IN 1 .. 10 LOOP UPDATE ss SET C2= 'AAAA1+' || I WHERE C1 BETWEEN 0 AND 100; COMMIT; sys.DBMS_LOCK.sleep (5); END LOOP; END; / 删除数据BEGIN FOR I IN 1 .. 10 LOOP DELETE FROM ss WHERE C1 BETWEEN I AND I; COMMIT; sys.DBMS_LOCK.sleep (5); END LOOP; END; / (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |