tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

Oracle/PLSQL: RTRIM Function

Learn how to use the Oracle/PLSQL RTRIM function with syntax and examples.

Description

The Oracle/PLSQL RTRIM function removes all specified characters from the right-hand side of a string.

Syntax

The syntax for the Oracle/PLSQL RTRIM function is:

RTRIM( string1, [ trim_string ] )

Parameters or Arguments

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.

Note

Applies To

The RTRIM function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example

Let's look at some Oracle RTRIM function examples and explore how to use the RTRIM function in Oracle/PLSQL.

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.