Share

0x66 ORACLE - MASS UPDATE IP NET C/B

update net C

UPDATE IPWC_TEST SET
IP='_NEW.NET.C_.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 4))
WHERE
TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 1))||'.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 2))||'.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 3))='_OLD.NET.C_'

update net B

UPDATE ipwarmer_config SET
IP='_NEW.NET_B_.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 3))||'.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 4))
WHERE
TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 1))||'.'||TO_NUMBER(REGEXP_SUBSTR(IP, '[0-9]+', 1, 2))='_OLD.NET_B_'

 

1453988220