Skip to Main Content
  • Questions
  • Extract Data From Blob file Column (xml,json,xlsx,csv)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Praveen.

Asked: October 27, 2020 - 4:36 am UTC

Answered by: Connor McDonald - Last updated: October 28, 2020 - 6:02 am UTC

Category: PL/SQL - Version: 19c

Viewed 100+ times

You Asked

Hi,

In apex i can able to extract data from EXCEL using XLSX PARSER, but in my case user uploading the file based on the file type (Ex: EXCEL/CSV/JSON/XML) i'm storing into as a blob column.

i want to extract the data(from Blob column) based on the type and i want to storing into another table as a records.

Is there any option to extract the data from blob column.

Please provide any sample.

Thanks,
Praveen

and we said...

APEX_DATA_PARSER is what you are going to want for that. It covers a whole suite of data transformations.

Take a look at this article by Tim Hall. It looks like it covers exactly what you have just specified.

https://oracle-base.com/articles/misc/apex_data_parser


More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.