Wednesday, April 18, 2007

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;

No comments: