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!

delete extra spaces in table column

Tony007Dec 3 2012 — edited Dec 3 2012
hi how can i delete extra spaces in table column for example if table column value is store as 'ÄAAAAA ' how can i delete that extra space

this is the column i what to delete extra spaces
select SUBTYPES  from tablesubtype;
am in
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

Edited by: adf0994 on 2012/12/03 11:30 AM

Edited by: adf0994 on 2012/12/03 11:42 AM
This post has been answered by 915396 on Dec 3 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2012
Added on Dec 3 2012
4 comments
5,071 views