22.23 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

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

Signature 2

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

Parameters

Table 22-21 GET_DATA_TYPE Function 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.