Wiki: TRIM

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor