oracle中trim函数的用法

最新推荐文章于 2024-03-18 00:27:06 发布

原创最新推荐文章于 2024-03-18 00:27:06 发布 · 1w 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #string #character #function #ie

数据库专栏收录该内容

28 篇文章

订阅专栏

本文详细介绍了Oracle数据库中TRIM函数的使用方法，包括如何去除字符串前后指定字符的功能，并通过多个实例展示了不同参数组合下TRIM函数的具体应用。

转载出处：http://blog.youkuaiyun.com/E_wsq/archive/2009/11/14/4810757.aspx

oracle中trim函数的用法

In Oracle/PLSQL, the trim function removes all specified characters either from the beginning or the ending of a string.

The syntax for the trim function is:

trim([leading|trailing|both[trim_character]] string1)

leading - remove trim_string from the front of string1.

trailing - remove trim_string from the end of string1.

both - remove trim_string from the front and end of string1.

If none of these are chosen (ie: leading, trailing, both), the trim function will remove trim_string from both the front and end of string1.

trim_character is the character that will be removed from string1. If this parameter is omitted, the trim function will remove all leading and trailing spaces from string1.

string1 is the string to trim.

For example:

trim(' tech ') would return 'tech'
trim(' ' from ' tech ') would return 'tech'
trim(leading '0' from '000123') would return '123'
trim(trailing '1' from 'Tech1') would return 'Tech'
trim(both '1' from '123Tech111') would return '23Tech'