Oracle TRIM function

10/13/2015 - 2:31 PM

From http://www.techonthenet.com/oracle/functions/trim.php

TRIM('   tech   ')
Result: 'tech'

TRIM(' '  FROM  '   tech   ')
Result: 'tech'

TRIM(LEADING '0' FROM '000123')
Result: '123'

TRIM(TRAILING '1' FROM 'Tech1')
Result: 'Tech'

TRIM(BOTH '1' FROM '123Tech111')
Result: '23Tech'

Cacher is the code snippet organizer for pro developers

We empower you and your team to get more done, faster

Oracle TRIM function