---
title: "Discussion on \"Decoding Decode Data Types\" | Hashnode"
description: "Discussion on \"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:\ncreate or replace view mdsouza_temp as\nselect\n  decode(job, 'PRESIDENT', nu..."
url: "https://hashnode.com/posts/decoding-decode-data-types/64dcc9014429385b92804232"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Decoding Decode Data Types](https://talkapex.com/decoding-decode-data-types?utm_source=hashnode&utm_medium=feed)

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...

Dec 27, 2012 · 2 min read · talkapex.com  
Read the article

## Written by

[Martin Giffy D'Souza](https://hashnode.com/@martindsouza)

@martindsouza · Calgary, Alberta, Canada

  
[View profile](https://hashnode.com/@martindsouza)

Oracle APEX Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.