Remove last character from a string in oracle sql

 SELECT SUBSTR('ABCD', 1, LENGTH('ABCD') - 1) FROM DUAL;