15.19 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 15-17 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.