In a particular table has a column created to register documents, RG, Varchar2 type. Only values ??with points (.) Virgula, letters, garbage.
I want to make an update to leave only the numbers.
I created a routine using Translate, but it gets crazy and updates fields by placing letters on them.
What to do?
follows code:
update enderecos_clientes
SET RG=translate(upper(rg),'ABCDEFGIJLMNOPRSTU,./-;:\_',' ')
where ...