Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle LTRIM Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: LTRIM

Definition:
The Oracle LTRIM function removes leading spaces from a string or column. Space characters are the default, but you can also specify the character(s) to be removed. Characters can be specified as literals ('A', 'm', etc) or by their CHR equivalents: 'CHR(112)', 'CHR(68)'.

The LTRIM function returns a value with datatype VARCHAR2.

Example (Default) Syntax:

LTRIM();


Example Syntax for specifying a literal character:

SELECT LTRIM('Z' FROM 'Zebra') FROM dual;


Example Syntax for specifying a character by its CHR() value:

SELECT LTRIM(CHR(90) FROM 'Zebra') FROM dual;


Also See:
Definition & Examples: TRIM Function
Definition & Examples: RTRIM (Right Trim) Function

Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 208 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?