Oracle SQL - Using TRIM function

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

Introduction

TRIM function removes a set of characters from both sides of a string.

The general format for this function is: 

TRIM ([{leading_characters | trailing_characters | both} 
[trim_character]) | 
     trim_character} FROM | source_string)

Demo

SQL>
SQL> SELECT TRIM(trailing 's' from 'Cars') FROM dual ;

TRI-- from   w  w w  .jav  a  2  s .  c  om
---
Car

SQL>

Related Topic