2015-12-30

how to find enter or space inside columns content


select
    '|' || a.colname || '|'
from
    tablename a
where
    instr(a.codename, chr(13)) != 0
    or instr(a.codename, chr(10)) != 0

Niciun comentariu:

Trimiteți un comentariu