Oracle SQL - Function RTRIM function

  1. HOME
  2. Oracle SQL
  3. Function
  4. RTRIM function

Introduction

RTRIM function removes a set of characters from the right of a string.

RTRIM stands for "right trim."

The general format for this function is: 

RTRIM(string, characters_to_remove)

Demo

SQL>
SQL>-- from   w  w  w  .  j a  v a  2s  .co m
SQL> SELECT RTRIM('Tests', 's') FROM dual;

RTRI
----
Test

SQL>