18.20 GET_DATA_TYPE Functions

This function converts the t_data_type constant into the VARCHAR2 representation . Converts a data type VARCHAR2 representation to the t_data_type constant.

Syntax

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

Signature 1

FUNCTION GET_DATA_TYPE( 
    p_datatype_num in varchar2 ) RETURN apex_exec.t_data_type;

Parameters

Table 18-18 GET_DATA_TYPE Functions 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

VARCHAR2 representation of the data type, as used by SQL

Signature 1

Data type constant of apex_exec.t_data_type.