Decoding Decode Data Types

I ran into a strange issue in APEX a while ago which was due to a decode statement not returning the data type that I expected. Here’s a sample of what the query looked like: create or replace view mdsouza_temp as select   decode(job, 'PRESIDENT', nu...