title: Searching for newlines in a Oracle DB using SQL 'like' clause
body: <p>I'm trying to see if a particular column in a table in my Oracle database has any strings which contain a newline character, so a wildcard, a newline, and another wildcard. </p>
  
  <p>I've tried the like command and a combination with CHR(10) and tried escaping the newline itself, but to no avail. What would be the proper way to detect a newline in somewhere within a string?</p>
  
  <p>Thanks!</p>