Oracle Trim Syntax

Posted by die van niekerkuu's on
rtrim( string1, [ trim_string ] )

Examples:

rtrim('tech ');
would return 'tech'

rtrim('tech ', ' ');
would return 'tech'

rtrim('123000', '0');
would return '123'

rtrim('Tech123123', '123');
would return 'Tech'

rtrim('123Tech123', '123');
would return '123Tech'

rtrim('Techxyxzyyy', 'xyz');
would return 'Tech'

rtrim('Tech6372', '0123456789');
would return 'Tech'

Comments

Post a Comment