Hello, I started using APEX about 3-4 weeks ago now with no previous knowledge of SQL or PL/SQL coding. Currently, I am recreating the CRM backend for the company I work for in APEX (I'm the graphic and web designer so this has been quite the turn of events). I have gotten quite far, but there are a lot of PDFs I need to upload from the previous database we were using and put it into an APEX table as a BLOB.
One solution I thought of was uploading each file individually through a form using a bot (it would populate the ID, BLOB, name, MIMETYPE, ect. in the form) and have that run for a few days (there are 12k-ish PDFs to upload).
But, I want to know if there is an easier way to do this or something I am missing. I have been working 100% in APEX and not using the SQL*Loader due to not knowing SQL that well. However, if given better guidance I think it will help a lot and allow me to start using SQL*Loader. If there is a solution that allows me to stay completely in the APEX dash though that would be amazing.
Thank you in advance and any solutions you have, but remember I am very new to this and still learning.