PLSQL | RTRIM Function
The PLSQL RTRIM function is used for removing all specified characters from the right-hand side of a string. The PLSQL RTRIM function accepts two parameters which are input_string and trim_string.
- If the user does not specify trim_string, it defaults to a single blank.
- If char is a character literal, then you must enclose it in single quotes.
Oracle Database begins scanning char from its first character and removes all characters that appear in trim_string until reaching a character not in trim_string and then returns the result.
Syntax:
LTRIM( input_string [, trim_string] )
Parameters Used:
- input_string – It is used to specify the string whose characters need to be trimmed from the right hand side.
- trim_string – It is an optional parameter which is used to specify the string that will be removed from the right-hand side of input_string. If this parameter is omitted, the RTRIM function removes all leading spaces from input_string.
Supported Versions of Oracle/PLSQL:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
Example-1:
DECLARE Test_String string(25) := 'Geeksforgeeks '; BEGIN dbms_output.put_line(RTRIM(Test_String)); END;
Output:
Geeksforgeeks
Example-2:
DECLARE Test_String string(25) := 'Geeksforgeeks '; BEGIN dbms_output.put_line(RTRIM(Test_String, ' ')); END;
Output:
Geeksforgeeks
Example-3:
DECLARE Test_String string(25) := 'Geeksforgeeks123'; BEGIN dbms_output.put_line(RTRIM(Test_String, '123')); END;
Output:
Geeksforgeeks
Example-4:
DECLARE Test_String string(25) := 'Geeksforgeeks123123'; BEGIN dbms_output.put_line(RTRIM(Test_String, '123')); END;
Output:
Geeksforgeeks
Example-5:
DECLARE Test_String string(25) := 'Geeks123forgeeks123'; BEGIN dbms_output.put_line(RTRIM(Test_String, '123')); END;
Output:
Geeks123forgeeks
Recommended Posts:
- PLSQL | SIN Function
- PLSQL | COS Function
- PLSQL | LOG Function
- PLSQL | TAN Function
- PLSQL | MOD Function
- PLSQL | LEAST Function
- PLSQL | EXP Function
- PLSQL | LN Function
- PLSQL | CHR Function
- PLSQL | ABS Function
- PLSQL | SIGN Function
- PLSQL | CONCAT Function
- PLSQL | TANH Function
- PLSQL | CURRENT_TIMESTAMP Function
- PLSQL | CURRENT_DATE Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




