Details
-
Question
-
Resolution: Done
-
Minor - P4
-
None
-
2.4.0
-
None
-
None
Description
1) select f1 as field_one from table;
so f1 is aliased to field_one.
2) select decode(f1, 1,one, 2, two, 3, three, 'Not a valid range' ) from table.
so for value of f1 query returns
1 One
2 Two
3 Three
else
Not a valid range