Hello
I am new to Oracle and creating scripts. I need to run multiple update statements, for 1000+ records but they haven't come up with any selection criteria which I think it will be so much easier. I need to manually run the following. I will be grateful for any help you can provide.
UPDATE NONCONFORM SET WORK_CENTER = 'xxx' WHERE BUSINESS_UNIT = @BU AND NC_STATUS = 'CLS' AND NC_TYPE = 'NW'
AND NCNUMBER IN ('NC123456')
I also tried using this, but I get this message ERROR: Line 1, column 9, endling line 1, column 9: Found ‘@’: Expecting: BEGIN or CURSOR FUNCTION identifier PRAGMA PROCEDURE substition_variable SUBTYPE_TYPE
DECLARE @BU VARCHAR(3) = ‘ZZZ’
UPDATE NONCONFORM SET WORK_CENTER = 'xxx' WHERE BUSINESS_UNIT = @BU AND NC_STATUS = 'CLS' AND NC_TYPE = 'NW'
AND NCNUMBER IN ('NC123456')
UPDATE NONCONFORM SET WORK_CENTER = 'xxx' WHERE BUSINESS_UNIT = @BU AND NC_STATUS = 'CLS' AND NC_TYPE = 'NW' AND NC_REFERENCE_DOC = 'RF123456"
AND NCNUMBER IN ('NC123456', ‘NC78910, ’NC11121314')
UPDATE NONCONFORM SET WORK_CENTER = 'xxx' WHERE BUSINESS_UNIT = @BU AND NC_STATUS = 'CLS' AND NC_TYPE = 'NW' AND NCNUMBER IN ('NC123456', ‘NC78910, ’NC11121314')
I am trying find a way that it will not be thoroughly slow for me to update all these records.