[注]:部分转载,部分原创
几个实例:
1:
SQL> select ltrim('109224323','109') from dual;
LTRIM('109224323','109')
------------------------
224323
2:
SQL> select ltrim('10900094323','109') from dual;
LTRIM('10900094323','109')
---------------------------
4323
3:
SQL> select ltrim('10900111000991110224323','109') from dual;
LTRIM('10900111000991110224323
------------------------------
224323
4:
SQL> select ltrim('109200111000991110224323','109') fromdual;
LTRIM('10920011100099111022432
------------------------------
200111000991110224323
5:
SQL> select ltrim('902100111000991110224323','109')from dual;
LTRIM('90210011100099111022432
------------------------------
2100111000991110224323
总结:ltrim(x,y) 函数是按照y中的字符一个一个截掉x中的字符,并且是从左边开始执行的,只要遇到y中有的字符, x中的字符都会被截掉, 直到在x的字符中遇到y中没有的字符为止函数命令才结束.