Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to remove spaces in select statement

758635Apr 8 2010 — edited Mar 7 2013
Hi ,
I have a sql like
select TRIM(column_name)
    from user_tab_columns
    where table_name = 'MTL_SYSTEM_ITEMS_VL' AND COLUMN_NAME   IN ('DESCRIPTION     ');

no rows selected
But if i remove the spaces after 'DESCRIPTION'
select TRIM(column_name)
    from user_tab_columns
    where table_name = 'MTL_SYSTEM_ITEMS_VL' AND COLUMN_NAME   IN ('DESCRIPTION');

One Row Selected 
Like this i have many rows .
What clause other than trim i should apply to no cosider the spaces?

Thanks
This post has been answered by SKavi on Apr 8 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2013
Added on Apr 8 2010
17 comments
55,230 views