Skip to content

Instantly share code, notes, and snippets.

@klascano
Created August 4, 2014 15:48
Show Gist options
  • Save klascano/3e64e3c3c9fe370a01ea to your computer and use it in GitHub Desktop.
Save klascano/3e64e3c3c9fe370a01ea to your computer and use it in GitHub Desktop.
remover caracter salto de lines #oracle
update eeasa_tra_comentario
set etco_comentario = replace(replace(etco_comentario,chr(10),' '),chr(13),' ')
where (instr(etco_comentario,chr(10))>0 OR instr(etco_comentario,chr(13))>0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment