Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
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 ;
Join the community of 500,000 technology professionals and ask your questions.