Let’s revisit the ways to programmatically load data into an on-premise or Cloud Oracle database. Many applications need to load data from external sources as some part of the workflow. What is the best data load option for your environment and your requirements? Is your spreadsheet data CSV or true XLSX? Are you loading CLOBs or LOBs? What are the APEX data load options? Which data load methods work in a Cloud database? What methods make most sense for your users, for your environment, for your budget? This presentation reviews a collection of data load options, including the APEX Data Load wizard, external tables, ORDS bulk data load, open source interfaces, plugins and APEX APIs helpful for custom coding.
Demonstrations and examples are geared toward APEX applications, yet most of the techniques described can be used in any PL/SQL application. Attendees gain sufficient knowledge to make an intelligent choice for their application data loading needs.