Oracle PL/SQL: String Functions: RTRIM - The rtrim function removes all specified characters from the right-hand side of a string.<br />

Quick Search:

Oracle PL/SQL: String Functions: RTRIM

Jump to:

Category: >> Oracle PL/SQL >> String Functions: RTRIM

Snippet Name: String Functions: RTRIM

Description: The rtrim function removes all specified characters from the right-hand side of a string.

Also see:
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» SUBST and INSTR together
» INSTR (InString)
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH
» String Functions: INSTR
» String Functions: CONCAT
» String Functions: CHAR
» String Functions: INITCAP
» String Functions: LOWER
» String Functions: UPPER
» Date Functions: NUMTOYMINTERVAL

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SELECT RTRIM('abc000', '0') FROM dual; 
returns 'abc' 
 
SELECT RTRIM('abc123123', '123') FROM dual; 
returns 'abc'

Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us

© 2003 - 2024 psoug.org