摘要: create or replace procedure pro_cursor_delete( inpit_taid number)as v_taid number;cursor c_delete is select taid from table3 where taid=inpit_taid for update of taid; --锁定taid列的单行值,防止所有的数据被删除了beginopen c_delete;loopfetch c_delete into v_taid; exit when c_delete%notfound; delete table3 where taid=inp 阅读全文
posted @ 2012-06-13 21:48 blog_yuan 阅读(1399) 评论(0) 推荐(0) 编辑