REGEXP_SIMILAR - To identify new line characters

[tera_user]

Hi,

How to identify if a column has new line characters or not using REGEXP_SIMILAR.

There is a column in my table which has new line characters but when I use as mentioned below it is not working ..

    REGEXP_SIMILAR(<COL>,X'0A')=1

Please suggest

[Fred]

POSITION('0A'xc IN <col>) > 0 would likely be a better solution in this case.

If you really want to use REGEXP_SIMILAR, then the pattern must be something that will match the entire column value, e.g. '.*'||'0A'xc||'.*'

[tera_user]

Thanks Fred for the details.

Both are working but i am getting different count when querying on same table.

[Fred]

Then for REGEXP_SIMILAR, specify the 'n' option as the third parameter - so the pattern can match strings with more than one "new line".

[tera_user]

Thanks Fred it is working fine now ..getting same count