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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: LTRIM & RTRIM

RE: LTRIM & RTRIM

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 21 Mar 2005 07:36:35 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC037D@exchsen0a1ma>


Kean,

LTRIM trims from the left and RTRIM trims from the right. So they are sort of the same but from different directions.

Tom

-----Original Message-----

From: Kean Jacinta [mailto:jacintakean_at_yahoo.com] Sent: Sunday, March 20, 2005 11:31 PM
To: oracle-l_at_freelists.org
Subject: LTRIM & RTRIM

Need some clarification here.

WHILE V_FROMDate <= TODATE LOOP

   IF RTRIM(TO_CHAR(V_FROMDate,'DAY'))='SATURDAY' THEN    V_Count := V_Count + 1;
   END IF;
   V_FROMDate := V_FROMDate +1;

When i use RTRIM --it will generate correct result , if i use LTRIM then the system will return 0.

Aren't RTRIM and LTRIM sort of the same ?

PLs help up . THank u                 



Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 21 2005 - 07:49:12 CST

Original text of this message

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