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

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle