Oracle SQL - Function LTRIM function

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

Introduction

LTRIM function removes a set of characters from the left of a string. LTRIM stands for "left trim."

The general format for this function is: 

LTRIM(string, characters_to_remove)

Demo

SQL>
SQL>--  w  ww .  j  a va  2 s  .  co  m
SQL> SELECT LTRIM('...Test', '.') FROM dual
  2