Oracle PL/SQL Trim Function
The Trim function removes all specified characters from the beginning or from the ending of a string.
The Trim Function syntax:
trim( [ leading | trailing | both [ trim_character ] ] string )
Leading – remove trim_character from the front of string.
Trailing – remove trim_character from the end of string.
Both – remove trim_character from the front and end of string.
select trim(' test ') from dual; would return 'test' select trim(leading '0' from '0004560') from dual; would return '4560' select trim(trailing '6' from 'Forms6') from dual; would return 'Forms' select trim(both '3' from '3Tutorial333') from dual; would return 'Tutorial'