17 APEX_DATA_PARSER

This package contains the implementation for the file parser in APEX. APEX_DATA_PARSER supports XML, JSON, CSV and XLSX files. The most important function in this package is the PARSE function, which is implemented as a table function returning rows of the APEX_T_PARSER_ROW type. The parser supports up to 300 columns.

• Global Constants
  
• Data Types
  
• ASSERT_FILE_TYPE Function
  
• DISCOVER Function
  
• GET_COLUMNS Function
  
• GET_FILE_PROFILE Function
  
• GET_FILE_TYPE Function
  
• GET_XLSX_WORKSHEETS Function
  
• JSON_TO_PROFILE Function
  
• PARSE Function