OraFAQ Forum: Server Administration » removing space and tab script

Home » RDBMS Server » Server Administration » removing space and tab script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

removing space and tab script [message #53971]

Tue, 22 October 2002 10:19

tony t
Messages: 4
Registered: October 2002

Junior Member

Hello,
I have a column whose data has trailing spaces and tabs.. What update statement can I run to get rid of the trailing tabs and spaces? Thank you,

Report message to a moderator

Re: removing space and tab script [message #53972 is a reply to message #53971]

Tue, 22 October 2002 10:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> ed
Wrote file afiedt.buf

  1* select name,length(name),rtrim(name,' '),length(rtrim(name,' ')) from test2
SQL> /

NAME       LENGTH(NAME) RTRIM(NAME LENGTH(RTRIM(NAME,''))
---------- ------------ ---------- ----------------------
new                   7 new                             3
newa                  4 newa                            4
sdf                   3 sdf                             3
ddd  dd d             9 ddd  dd d                       9

Report message to a moderator

Previous Topic:	Archivelog Mode
Next Topic:	Migrating from 8i to 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 00:29:58 CST 2024