Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. From_template argument can contain more characters than to_template
SQL>
SQL> SELECT
  2       TRANSLATE('4428-2174-5093-1501'
  3                ,'0123456789-'
  4                ,'XXXXXXXXXX*')  hide_num
  5  FROM dual;
HIDE_NUM
-------------------
XXXX*XXXX*XXXX*XXXX