Skip to Main Content
Forums

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!

using TRIM function in select statement

678047Mar 22 2010 — edited Mar 22 2010
Hi All,

I'm using the TRIM function in my select statement to eliminate the white spaces.
But while using in select the TRIM function is not working in SQL*PLUS client(The query returns the white spaces also)

Kindly provide some pointers regarding the issue.........

I want to get only the data without the spaces in select statement

Regards,
Mohan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2010
Added on Mar 22 2010
#sql
3 comments
1,374 views