|Oracle8i SQL Reference
Release 2 (8.1.6)
Functions, 108 of 121
TRIM enables you to trim leading or trailing characters (or both) from a character string. If trim_character or trim_source is a character literal, you must enclose it in single quotes.
LEADING, Oracle removes any leading characters equal to trim_character.
TRAILING, Oracle removes any trailing characters equal to trim_character.
BOTHor none of the three, Oracle removes leading and trailing characters equal to trim_character.
VARCHAR2. The maximum length of the value is the length of trim_source.
TRIMfunction returns a null value.
This example trims leading and trailing zeroes from a number: