title: Hi I've written a query in mysql (that works) that I'd like to execute on oracle sql developer, so I am trying to write it in pl/sql
body: <p><strong>This is the query i am trying to replicate</strong></p>
  <pre><code>SELECT (
          CASE
              WHEN City like '%Berlin' and CustomerName like '%kiste'
                       THEN &quot;CORRECT&quot;
                    ELSE &quot;INCORRECT&quot;
               END) as Result, CustomerName, City
  FROM Customers
  </code></pre>
  <p>Basically, this would display a new 'result' column where if the values match would display correct else incorrect.</p>
  <p><strong>How do I script this in pl/sql? As i can't find a direct equivalent for the case statement</strong></p>