Oracle/PLSQL: Rtrim Function_oracle中的rtrim(,'0123456789')-CSDN博客

本文详细介绍了Oracle/PLSQL中的rtrim函数，用于从字符串的右侧删除指定字符。rtrim函数的基本语法是rtrim(string1, trim_string)，其中string1是要修剪的字符串，trim_string是待删除的字符。如果省略trim_string，则默认删除右侧的所有空格。文中通过多个示例展示了rtrim函数如何工作，包括移除单个字符、数字以及特定字符组合。请注意，rtrim函数不会按模式删除字符，而是逐个删除指定的字符。此外，还展示了如何利用rtrim函数去除字符串尾部的数字。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In Oracle/PLSQL, the rtrim function removes all specified characters from the right-hand side of a string.

Syntax

The syntax for the rtrim function is:

rtrim( string1, [ trim_string ] )

string1 is the string to trim the characters from the right-hand side.

trim_string is the string that will be removed from the right-hand side of string1. If this parameter is omitted, the rtrim function will remove all trailing spaces from string1.

Applies To

Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

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'

The rtrim function may appear to remove patterns, but this is not the case as demonstrated in the following example.

rtrim('Techxyxxyzyyyxx', 'xyz');

would return 'Tech'

It actually removes the individual occurrences of 'x', 'y', and 'z', as opposed to the pattern of 'xyz'.

The rtrim function can also be used to remove all trailing numbers as demonstrated in the next example.

rtrim('Tech6372', '0123456789');

would return 'Tech'

In this example, every number combination from 0 to 9 has been listed in the trim_string parameter. By doing this, it does not matter the order that the numbers appear in string1, all trailing numbers will be removed by the rtrim function.