Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LTRIM & RTRIM
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