TRIM#

Functionality:#

This Oracle function will remove characters on the left or right or both (usually spaces)

Parameters: #

LOCATION (optional) Where in the string you want the characters removed. Can be LEADING, TRAILING or BOTH. If not specified, BOTH is used
REMOVESTR (optional) The characters that you want removed. If not specified then white space will be removed
STRING The target string to be worked on.

Returns: #

Text

Errors: #

None

Operations: #

If LOCATION is provided the keyword FROM must also be included.

Example:#

TRIM(LEADING '0'FROM ~) will remove all leading zeroes from the passed string


Notes #

Click to create a new notes page