I have one field X in my table and want to trim spaces, remove non-numeric value, left pad to 16 digit with leading zeroes. How can I achieve this like REGEXP_REPLACE is not supported?
I tried with REGEXP_REPLACE is not supported
I have one field X in my table and want to trim spaces, remove non-numeric value, left pad to 16 digit with leading zeroes. How can I achieve this like REGEXP_REPLACE is not supported?
I tried with REGEXP_REPLACE is not supported