How to load data into table from csv,json,tsv,xlsx file in oracle apex.

It is very easy to load data from csv,json,tsv,xlsx file to database table using apex_data_parser API.

select line_number, col001, col002, col003, col004, col005, 
                    col006, col007, col008, col009, col010
                    -- more columns (col011 to col300) can be selected here.from apex_application_temp_files f, 
       table( apex_data_parser.parse(
                  p_content                     => f.blob_content,
                  p_add_headers_row             => 'Y',
                  p_max_rows                    => 5,
                  p_skip_rows                   => 2,
                  p_csv_col_delimiter           => ';',
                  p_store_profile_to_collection => 'FILE_PARSER_COLLECTION',
                  p_file_name                   => f.filename ) ) p
 where = :PX_FILE

10 views0 comments

Recent Posts

See All

How to create network ACL in oracle database.

when you are calling third party API in oracle using UTL_HTTP then you will face Network access denied by ACL error if ACL is not created. To create ACLfirst login with sys account then run below code

Check if you have any user that’s expired/lock

Error : The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured SELECT username, account_status, created,