Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to write oracle update sentences, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

The writing of the association of two tables in update includes word query

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

two。

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 minute temptation rolekeeper 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.