title: Oracle query to identify columns having special characters
body: <p>I'm trying to write a SQL query to return rows which has anything other than 
  <code>alphabets</code>, <code>numbers</code>, <code>spaces</code> and <code>following chars '.', '{','[','}',']'</code>
  Column has alphabets like <code>Ÿ</code>, <code>¿</code></p>
  
  <p>eg:- There's a table <code>TEST</code> with 2 columns - <code>EmpNo</code> and <code>SampleText</code>
  <code>EmpNo</code> is simple sequence and <code>SampleText</code> has values like</p>
  
  <pre><code>('12345abcde','abcdefghij','1234567890','ab c d 1 3','abcd$%1234','%^*&amp;^%$#$%','% % $ #  %','abcd 12}34{','MINNEAŸPOLIS','THAN ¿VV ¿A')
  </code></pre>
  
  <p>I want to write a query which should eliminate all rows which have even a single special character except <code>.{[}]</code>. In above example, it should return <code>EmpNo - 1,2,3,4 and 8</code>
  I tried <code>REGEXP_LIKE</code> but I'm not getting exactly what I need.</p>
  
  <p>Query I used:</p>
  
  <pre><code>SELECT * FROM test 
  WHERE REGEXP_LIKE(sampleText, '[^A-Z^a-z^0-9^[^.^{^}]' ,'x'); 
  </code></pre>
  
  <p>This is not ignoring blanks and I also need to ignore closing bracket ']' </p>