How to remove characters from the left side of a text expression in Oracle

In Oracle LTRIM function removes all the characters matching string from the left side of Characters. The syntax for the LTRIM function is: LTRIM(character,Removing String)
For Example:

SELECT LTRIM('FOREST','FOR') FROM DUAL;

Result: EST

Comments

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

How to Create Packages in Oracle Database using TOAD for Oracle

How to create a Simple Scheduler Job in Oracle Database using Toad