sql:关于Oracle的update from语句

作者：Cpp五条 | 2024-04-25 15:24:46

踩

oracle update from语句

还是带有SQL Server的习惯，在Oracle中经常使用update from结构，事实上Oracle中是不存在from语句的。

Code
1

update hek_om_pop_lines_all
2

set quantity_2 = quantity_1
3

from hek_om_pop_lines_all l, hek_om_pop_headers_all h, hek_om_user_ctl_v ctl
4

where l.header_id = h.header_id
5

and h.sold_to_org_id = ctl.customer_id
6

and h.flow_status = 'enter'
7

and to_char(h.creation_date,'yyyymmdd') >= &p_start_date
8

and to_char(h.creation_date,'yyyymmdd') <= &p_end_date
9

and ctl.user_id = 1115 -- apps.fnd_profile.VALUE('user_id')
10

and application = 'POP';

error：ORA-00933:SQL Command not properly ended

Code
1

update hek_om_pop_lines_all
2

set quantity_2 = quantity_1
3

where header_id in (select h.header_id
4

from hek_om_pop_headers_all h, hek_om_user_ctl_v ctl
5

where h.flow_status = 'enter'
6

and to_char(h.creation_date,'yyyymmdd') >= &p_start_date
7

and to_char(h.creation_date,'yyyymmdd') <= &p_end_date
8

and ctl.user_id = 1115 -- apps.fnd_profile.VALUE('user_id')
9

and application = 'POP'
10

and h.sold_to_org_id = ctl.customer_id);

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/486008