title: Oracle SQL String starts with ‘987’ or ‘I’
body: <p>I am using Oracle SQL Developer. I need to find the rows where column1 starts with ‘987’ or ‘I’. Column1 is a String(18). Some sample patterns in this column include: 9(9), 9(12), and others. I am not familiar with the code to see how a column starts with certain values in Oracle SQL. Sample Code is below. Attempt below.</p>
  
  <p>Code</p>
  
  <pre><code>select * from table1
  where column1
  </code></pre>
  
  <p>Attempt Code</p>
  
  <pre><code>SELECT
    REGEXP_SUBSTR(column1,
                  '987') "REGEXP_SUBSTR"
    FROM table1;
  </code></pre>