Home Replace of NOT REGEXP_LIKE from Oracle to Postgres
Reply: 0

Replace of NOT REGEXP_LIKE from Oracle to Postgres

user731
1#
user731 Published in April 26, 2018, 1:44 pm

Please help me how to Migrate to Postgres the below Code which uses NOT REGEXP_LIKE In Oracle:

  UPDATE TBL_RESOURCEAVAILUPLOAD
    SET IS_VALID_AVAILABILITY = 0,
      ERROR_CODE = 'DATA-ERR',
      ERROR_MESSAGE = CONCAT(ERROR_MESSAGE,' Start date or end date is not in proper format. It should be in MM/DD/YYYY format.,')
        WHERE ( **NOT REGEXP_LIKE** (STARTDATE, '(0[0-9]|1[0-2])/(0[0-9]|1[0-9]|2[0-9]|3[0-1])/([0-9][0-9][0-9][0-9])')
                        OR
                        **NOT REGEXP_LIKE** (ENDDATE, '(0[0-9]|1[0-2])/(0[0-9]|1[0-9]|2[0-9]|3[0-1])/([0-9][0-9][0-9][0-9])') )
                     AND BATCH_ID = 21354
                      AND COUNTRY_ID = '76';
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.531598 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO