oracle 的更新语句如下:
UPDATE tbl_phone_base SET sex = 1
WHERE length(idcard)=18 and substr(idcard,17,1) in ('1','3','5','7','9');怎样改写成存储过程?
UPDATE tbl_phone_base SET sex = 1
WHERE length(idcard)=18 and substr(idcard,17,1) in ('1','3','5','7','9');怎样改写成存储过程?
create or replace procedure up_table
as
begin
UPDATE tbl_phone_base SET sex = 1
WHERE length(idcard)=18 and substr(idcard,17,1) in ('1','3','5','7','9');
commit;
end;
楼主你这问题问的,一个简单的DML语句能搞定,为什么还想着用过程