Re: Update table problem

Maybe: update tbl set col=replace(col,' ',''); Harvinder Singh pe: Hi, We inserted data into 1 of the column as test 1 abc while the actual value is test1abc without spaces. There are about 1 million rows in a table. Is there a way to update the table column and remove the extra

Re: Update table problem

hi, whether u want to update that row(with out space) or the entire column, if row alone means then the coding is update tbl set row = 'test1abc' where rname = 'test 1 abc' if u want to do for entire column make use of cursors or pl/sql by using trim for that column.

RE: Update table problem

recipients of list ORACLE-L Asunto: Update table problem Hi, We inserted data into 1 of the column as test 1 abc while the actual value is test1abc without spaces. There are about 1 million rows in a table. Is there a way to update the table column and remove the extra space . Thanks --Harvinder

Update table problem

Hi, We inserted data into 1 of the column as test 1 abc while the actual value is test1abc without spaces. There are about 1 million rows in a table. Is there a way to update the table column and remove the extra space . Thanks --Harvinder -- Please see the official ORACLE-L FAQ: