Re: Can you use RTRIM in select clause

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 26 Jan 1999 21:26:26 GMT
Message-ID: <36b832f1.30106310@192.86.155.100>

A copy of this was sent to asupcsi_at_cyberramp.net (if that email address didn't require changing) On Tue, 26 Jan 1999 20:46:11 GMT, you wrote:

>Hello,
>
>Is it possible to use rtrim in the select clause of an Oracle sql stmt? I
>cannot seem to make it work as below. This is in sqlplus.
>
>select rtrim(table_name) from user_tables;
>

whats not working?

SQL> select rtrim(table_name) from user_tables;

RTRIM(TABLE_NAME)

---

ARTICLES
CLASSIFICATION
COMMUNITIES
COMMUNITIES_SAVE
....

is there some error?

>Thanks,
>
>Clay
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jan 26 1999 - 15:26:26 CST