TRIM

=TRIM=

Syntax
code code
 * TRIM**(LEADING|TRAILING|BOTH //trim_char// FROM //trim_source//)

Examples:
SELECT TRIM ('d', from 'dumb') From dual
 * TRIM ('d', from 'dumb') ||
 * umb ||

SELECT TRIM('R', from 'Rocco') From employees
 * TRIM('R', from 'Rocco') ||
 * occo ||

SELECT TRIM('s', from 'seida') From dual
 * TRIM('s', from 'seida') ||
 * eida ||