oracle sql - select statement with multiple "case when" and check for contains text
<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>