i am sorry but i need another pl/sql help from you guys.. sorry nepalibhai...
is there any way to trim the all column data in one statement. for example i have 20,000 data in a column and the values are using up my bytes. i need to trim all the whitespaces after the values.
my column datatype is char(65) some values are above 50bytes. the actual values are no more than 40bytes but it counts the whitespaces after the data so some are above 50bytes which i need to trim.
i used the syntax,
select trim ( both ' ' from column_name) from table_name
which of course didnt work..tried looking over the iternet.. no help there or at least i didnt type the right words...
please guys... if you could help me on this.. i would really really appreciate it.