Funções Oracle TRIM

SELECT RTRIM ('      Aprenda PL/SQL          ') FROM dual;

SELECT RTRIM('Aprenda PL/SQL', 'PL/SQL') FROM dual;

SELECT RTRIM('Aprenda Oracle_PL/SQL', 'SQL/Oracle_PL') FROM dual;

SELECT RTRIM('Aprenda Oracle_PL/SQL', 'Aprenda') FROM dual;

SELECT LTRIM ('      Aprenda PL/SQL         ') FROM dual;

SELECT LTRIM('Aprenda Oracle_PL/SQL', 'SQL/Oracle_PL') FROM dual;

SELECT LTRIM('Aprenda Oracle_PL/SQL', 'Aprenda') FROM dual;

SELECT TRIM ('   Aprenda PL/SQL   ') FROM dual;

SELECT TRIM(' '  FROM  '   Aprenda PL/SQL   ') FROM dual;

SELECT TRIM (leading '0' FROM '0001230') FROM dual;

SELECT TRIM(trailing 'x' FROM 'Aprendax') FROM dual;

SELECT TRIM (both 'x' FROM 'xxxAprendaxxx') FROM dual;