GET_DATA_TYPE Function

This function converts the t_data_type constant into the VARCHAR2 representation, or the data type VARCHAR2 representation to the t_data_type constant.

Syntax

Signature 1

APEX_EXEC.GET_DATA_TYPE (
    p_datatype_num      IN apex_exec.t_data_type )
RETURN VARCHAR2;

Signature 2

APEX_EXEC.GET_DATA_TYPE (
    p_datatype      IN VARCHAR2 )
RETURN apex_exec.t_data_type;

Parameters

Parameter	Description
`p_datatype_num`	Data type constant of `apex_exec.t_data_type`.
`p_datatype`	`VARCHAR2` representation of the data type, as used by SQL.

Returns

Signature 1

VARCHAR2 representation of the data type, as used by SQL

Signature 2

Data type constant of apex_exec.t_data_type.