Remove a letter from string with replace function
SQL>
SQL>
SQL> select REPLACE ('ABCDA', 'A','') remove_A from dual;
REMOVE_A
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
BCD
SQL>
SQL>
Related examples in the same category