Skip to Main Content
  • Questions

  • Read CSV from APEX Server and insert into Staging table

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: June 01, 2017 - 4:24 am UTC

Last updated: June 02, 2017 - 2:09 am UTC

Version: 5.1.1.00.08

Viewed 1000+ times

You Asked

Hi Tom,
I Have csv file on APEX server.I need to access file from server and read the records one by one and load into staging table through PLSQL coding.
Could you please provide the solution.

Thanks.

and Connor said...

Here's an example of parsing a clob of csv data into rows in a table.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9535071900346238234

You can easily adapt that to a file, because a file can be access as a bfile lob.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here