Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
create table order_line_package( Order_Line_Package_Id number(19,0) not null, Order_Package_Id number(19,0) not null, Order_No number(10,0) not null, Project_No varchar(8) not null, Entity varchar(15) not null, Line_No number (6,2) not null, Packed_Quantity number (10,2) not null ) ALTER TABLE order_line_package ADD CONSTRAINT order_line_package_PK PRIMARY KEY ( Order_Line_Package_Id ) ; ALTER TABLE order_line_package ADD CONSTRAINT order_line_package_unq unique( Order_No, Project_No, Entity, Line_No, order_package_id ) ;
update ( select sl.packed_quantity source_package_qty, dl.packed_quantity dest_package_qty from order_line_package sl --source lines join order_line_package dl --destination lines on sl.Order_No = dl.Order_No and sl.Project_No = dl.Project_No and sl.Entity = dl.Entity and sl.Line_No = dl.Line_No and sl.order_package_id = source_package_rec.order_package_id and dl.order_package_id = dest_package_rec.order_package_id ) set dest_package_qty = dest_package_qty + source_package_qty ;
|Need ideas on how to better approach the comparison of two different databases tables and show all the differences in a report.||18||58|
|Cannot open form error||6||26|
|PL/SQL Two PAYER_IDs with PAYER_TYPES these two types||4||14|
|Oracle Database Upgrade||13||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!