In Oracle, what is SQL querying for rows to appear?

Question

I need to find rows in which a specific column contains a row.

This does not work: select * from [table], where [column], for example '% \ n%'

In SO, I found a solution for SQL Server: New line in Sql query

But this does not work in Oracle. Is there an ANSI SQL solution? This should be standard ...

If not, what is the solution in Oracle?

Answer 1

An alternative to InStr (), which expresses SQL a bit more in line with this problem. IMHO.

select * from [table] where [column] like '%'||chr(10)||'%'

Answer 2

you can find the character CHR (10) (character for a new line):

select * from [table] where instr(column, chr(10)) > 0

Answer 3

Oracle 10g ,

select * from [table] where regexp_like([column], '\n')

Answer 4

* tableNameHere instr (colNameHere, chr (10)) > 0

Answer 5

As an alternative:

SELECT * FROM [table] WHERE column LIKE "%\n%"

\ n - string, \ r - carriage return ...