Para encontrar quebra de linha (chr(10)) em um campo CLOB

Para encontrar quebra de linha (chr(10)) em um campo CLOB:

select * from tabela where instr(col_clob,chr(10)) >0;

Posted in Java | No Comments »

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.