Oracle
走去打球了
这个作者很懒,什么都没留下…
展开
-
oracle 存储过程循环更新
create or replace procedure chushihua_code11 is v_code t_bas_sales_department.code%type; v_fid t_bas_businessdept.fid%type; cursor cur_track is select distinct bd.code fcode, bd.fid fid原创 2013-05-25 09:58:22 · 1691 阅读 · 0 评论 -
oracle关联表更新表多个字段
update t_bas_sales_department_626 s set (s.code,s.leave,s.pickup_self,s.delivery) =(select ofs.code,ofs.leave,ofs.pickup_self,ofs.delivery from (select distinct os.code,原创 2013-06-26 15:42:05 · 700 阅读 · 0 评论