TRIM Leading and Trailing Zeroes : TRIM « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. TRIM
SQL> SELECT TRIM (0 FROM 067270676800) "TRIM Example"
  2  FROM DUAL;

TRIM Exam
---------
672706768

SQL>
SQL>








11.15.TRIM
11.15.1.The TRIM Function
11.15.2.TRIM (both ' ' from ' String with blanks ')
11.15.3.Characters rather than spaces are trimmed
11.15.4.TRIM(leading 'F' from 'FABCDEF')
11.15.5.TRIM(trailing 'r' from 'Real water')
11.15.6.TRIM from both sides
11.15.7.Nested trim
11.15.8.TRIM Leading and Trailing Zeroes
11.15.9.Triming leading 'H' from employee last name
11.15.10.match trimmed string