title: oracle sql - select statement with multiple "case when" and check for contains text
body: <p>I look for  a working example where I can use mutliple when case statment wihch check to verify if a specific text is contained:
  e.g.</p>
  
  <pre><code>SELECT 
    ID,
    NAME,
    (SELECT 
        (Case when Contains(Descr,"Test") Then "contains Test" 
          when Contains(Descr, "Other") Then "contains Other"
          Else "No Match" End) From DESCRIPTION
         where item_id = id
    ) as "Match"
    From Item
  </code></pre>