Can anyone tell what is the error in this statement.
execute immediate 'Update '||tabs.table_name||' set ID_CTLGRP = REPLACE(ID_CTLGRP,'''','_') WHERE ID_CTLGRP LIKE '%''%'';
I am replacing apostrophes in a field by underscore for a number of tables.
Thanks you