Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. Remove a letter from string with replace function
SQL>
SQL>
SQL> select REPLACE ('ABCDA', 'A','')   remove_A from dual;
REMOVE_A
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
BCD
SQL>
SQL>