title: How to define default escape character in Oracle?
body: <p>I have table </p>
  
  <pre><code>id  name
  __________
  1   name1
  2   name2
  3   _name3
  </code></pre>
  
  <p>and I want to select all names, that starting with '_' character.</p>
  
  <pre><code>SELECT name FROM table1 WHERE name like '_%'
  </code></pre>
  
  <p>But this query returns all rows from table. Maybe anyone knows some solution for this problem (without using ESCAPE keyword)? Or, is there opportunity to set default escape character in Oracle?</p>