how to check new line character for all columns of the table
<p>Assume that there is table that named "GROUP_DETAILS" that has columns (NAME, CODE, DESCRIPTION).</p>

<p>So, the table looks like this:</p>

<p><a href="https://i.stack.imgur.com/rP7S3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rP7S3.png" alt="enter image description here"></a></p>

<p>I am trying to find new line character in all columns of the table. Then as soon as the column is found, I also want to show as a output. I have already created a script as below;</p>

<pre><code>DECLARE
BEGIN
  FOR r IN (select column_name from user_tab_columns where TABLE_NAME = 'GROUP_DETAILS') LOOP
    select r from GROUP_DETAILS where instr(r, chr(10)) &gt; 0;
  END LOOP;
END;
</code></pre>

<p>I am getting an error as below;</p>

<blockquote>
  <p>Error report -
  ORA-06550: line 4, column 48:
  PLS-00382: expression is of wrong type
  ORA-06550: line 4, column 12:
  PLS-00382: expression is of wrong type
  ORA-06550: line 4, column 5:
  PLS-00428: an INTO clause is expected in this SELECT statement
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:</p>
</blockquote>