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