oracle数据库中update,问一下oracle数据库update语句

update两表关联的写法包括字查询

1.update t2 set parentid=(select ownerid from t1 where t1.id=t2.id);

2. update tb_client_win_lost_report a set a.rolling_code_id=2

where game_code_id=70000

and exists

(select 'x' from (select a.id

from (select id,level_ from tb_admin_role connect by prior id=parent_id start with id =1) a,

(select lv_id from tb_rolling_plan where rolling_code_id = 2 and game_code_id=70000) b

where b.lv_id=a.id) c where a.role_id=c.id)

and rolling_code_id=1

3. update (select rolling_code_id from tb_client_win_lost_report a,temp_role_id b

where a.role_id=b.id

and rolling_code_id=1) a set a.rolling_code_id=2;

4. update tb_client_win_lost_report a set a.rolling_code_id=2

where game_code_id=70000

and exists

(select 'x' from (select id from temp_role_id) c where a.role_id=c.id)

and rolling_code_id=1

and rownum<100000;

commit;

5.update 多个字段的写法

update a set (c1,c2,c3) =(select b1,b2,b3 from b where......) where ......;

取消

评论