Hi
We have a big table (900M rows), In this table for around 50K rows,the column (col) has got non-alphanumeric characters which shouldn't be as there was no validation at the app side.
How could we strip out these non-alphanumeric characters so that only alphanumeric remains. I am using below sql but it is taking a lot of time
update data_table
set col = regexp_replace(broker_complex_trade_id, '[^A-Z0-9 ]', '')
where regexp_like(col, '[^A-Z0-9 ]')
The table is non partitioned and composite index on other 4 columns. The column which needs to be updated is not indexed.
Thanks