RE: LTRIM & RTRIM

From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
To: "'jacintakean@xxxxxxxxx'" <jacintakean@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
Date: Mon, 21 Mar 2005 07:36:35 -0500

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@xxxxxxxxx] 
Sent: Sunday, March 20, 2005 11:31 PM
To: oracle-l@xxxxxxxxxxxxx
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

RE: LTRIM & RTRIM

Other related posts: