[Oracle] LTRIM()

오라클 LTRIM()

 

LTRIM()

   -

 

LTRIM(char)

LTRIM(char, set)

의 형태

 

LTRIM removes from the left end of char all of the characters contained in set. If you do not specify set, then it defaults to a single blnak. If char is a character literal, then you must enclose it in single quotation marks. Oracle Database begins scanning char from its first character and removes all characters that apper in set until reaching a character not in set and then returns the result.

 

Both char and set can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 data type if char is a character data type, NVARCHAR2 if char is a national data type, and a LOB if char is a LOB data type.

 

SQL>SELECT LTRIM('   abcdefgabcdefg') FROM DUAL ;

   --> abcdefgabcdefg

 

SQL> SELECT LTRIM('abcdefgabcdefg', 'abcde') FROM DUAL ;

   --> fgabcdefg