help: Use of rtrim not working

From: Mike F <dbadba62_at_hotmail.com>
Date: Thu, 28 Feb 2002 12:17:55 GMT
Message-ID: <Tdpf8.1377$X%6.1131@nwrddc04.gnilink.net>

Some of our record has some strange white space at the end of the records and cause some trouble to our application.

SQL> update sqltest
  2 set sql_text=rtrim(sql_text);

4 rows updated.

SQL> update sqltest
  2 set sql_text=sql_text||'END';

4 rows updated.

SQL> select sql_text from sqltest;

SQL_TEXT

---

---

SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_P
RIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
 END SELECT USER FROM DUAL END
SELECT call_id , report_time , metro_id , roadway_id , direction_desc , sta
rt_point_id , end_point_id , call_sequence FROM RDE.VOICE_REPORT_HISTORY END SELECT point_id , file_name , closest_digital_point_distance , point_grammar
 , directory , closest_digital_point_id , crossing_roadway_id , crossing_poin
t_file_name FROM NAVTECH_TURKI.POINT_GRAMMAR END

We can see that there is a whitespace before the word "END", how can I get rid of this space?

Thanks for your help; Received on Thu Feb 28 2002 - 06:17:55 CST