oracle reverse enginee and select sql query with case

It is a important page to talk oracle walk though which table to reverse.
http://www.eveandersson.com/writing/data-model-reverse-engineering#columns

use Select sql query with case:
syntax
case when then
when then
...
else
end

sample:

select sal, case when sal < style="font-family: monospace;">'category 1'
                 else 'category 4' 
            end 
from emp;