Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Remove a letter from string with replace function

SQL> SQL> SQL> select REPLACE ('ABCDA', 'A','')   remove_A from dual; REMOVE_A -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- BCD SQL> SQL>