Oracle Identify Data Type

oracle, types

Solution

The Dump Function:

returns a VARCHAR2 value containing the datatype code, length in bytes, and internal representation of expr. The returned result is always in the database character set. For the datatype corresponding to each code, see Table 2-1.

Problem

Is there an Oracle function to return the data type of the parameter? Alternatively, what is the easiest way to determine the data type of all columns in a query that I've written?

Original source