Is there a way to add "CASE ... END" in oracle select query?

Jun 28, 2013 at 4:49 AM
Recently I encounter a situation where I need a conditional flag returned as a field depending on the query result.

Here is what I want to achieve:
select case when dummy is not null then 'Valid' else 'Invalid' end from your_table
Is there a way to achieve this using the library?