Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

updation of hz_cust-acct_sites_all

772932Jul 28 2011 — edited Jul 28 2011
hi friends
when i update ship_to_flag i got some error can any one help me this


update hz_cust_acct_sites_all
set SHIP_to_flag='P'
where ORIG_SYSTEM_REFERENCE = (SELECT CUST_ACCT_SITE_ID FROM HZ_CUST_ACCT_SITES_ALL);

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2011
Added on Jul 28 2011
6 comments
604 views