19.5 GET_COLUMNS Function

This function returns the columns of a parser profile as a table in order to be consumed by APEX components.

Syntax

FUNCTION GET_COLUMNS(
    p_profile             IN CLOB ) RETURN APEX_T_PARSER_COLUMNS;

Parameter

Table 19-3 GET_COLUMNS Function Parameters

Parameter	Description
P_FILE_PROFILE	File profile to be used for parsing. The file profile might have been computed in a previous PARSE() or DISCOVER() invocation.

Returns

Returns Profile column information as rows of APEX_T_PARSER_COLUMNS.

Example

This example uses DISCOVER() to compute a file profile and then GET_COLUMS() to return the list of columns among with their data types.

select *
      from table(
                  apex_data_parser.get_columns(
                      apex_data_parser.discover(
                          p_content => {BLOB containing XLSX file},
                          p_file_name=>'large.xlsx' )));

     COLUMN_POSITION COLUMN_NAME   DATA_TYPE   FORMAT_MASK      
     --------------- ------------- ----------- ------------------
                   1 C0            NUMBER                       
                   2 FIRST_NAME    VARCHAR2                     
                   3 LAST_NAME     VARCHAR2                     
                   4 GENDER        VARCHAR2                     
                   5 COUNTRY       VARCHAR2                     
                   6 AGE           NUMBER                       
                   7 DATE_         DATE        DD"/"MM"/"YYYY   
                   8 ID            NUMBER