TRIM « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. TRIM
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