Re: Can you use RTRIM in select clause

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 03 Feb 1999 12:59:09 -0500
Message-ID: <36B88E6D.E7D9990@sympatico.ca>

Works fine here as you can see.....

SQL> select rtrim(table_name) from user_tables;

RTRIM(TABLE_NAME)

DB_TAB_COLUMNS
EXCEL_TRACKED_ITEMS
SAVE_TRACKED_ITEMS

TRK_ACIT_NOTES
TRK_ACTION_ITEMS
TRK_COMPONENTS
TRK_COMPONENTS_DELIVERABLES
TRK_DELIVERABLES
TRK_DELIVERABLES_CATEGORIES
TRK_DOCUMENTS
TRK_DOCUMENTS_RESOURCES
TRK_GLOBAL_IDENTIFIERS
TRK_RESOURCES
TRK_RESOURCES_COMPONENTS
TRK_SUPPLIERS
TRK_TRACKED_ITEMS
TRK_TRIT_NOTES
WEB_STATES
WEB_STATE_INFOS

19 rows selected.

SQL> spool off

Karl R wrote:

> >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;
>
> Works for me! ;-)
Received on Wed Feb 03 1999 - 11:59:09 CST