Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ltrim() in Oracel 8.1.6

Re: ltrim() in Oracel 8.1.6

From: Kirmo Uusitalo <kirmo.uusitalo.no.spam_at_iki.fi>
Date: Tue, 23 Apr 2002 09:46:39 +0300
Message-ID: <mn0acugo1mmtj4s78stmlq9q9i8him64pr@4ax.com>


On 22 Apr 2002 20:27:32 -0700, zhuwang_at_yahoo.com (zhuwang) wrote:

>here are the output of several ltrim(), I really don't understand what
>is the purpose of ltrim(). How can I get the following results?
>Need your help and thanks.
>
>SQL> select ltrim('ascsa','asc') from dual;
>L
>-

SQL> select ltrim('__test__','_t') from dual;

LTRIM



est__

LTrim is normally used to remove space characters from the left of the string, but it accepts the 2nd parameter in which to specify which characters to remove from the start of the string.

HTH, Kirmo Uusitalo Received on Tue Apr 23 2002 - 01:46:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US