Loading Data Into Your Database Tips & Tricks
Some practical advice and how-to's for loading data (CSV, Excel, JSON, ...) to an Oracle Database using our tools, such as #SQL #Developer, SQL Developer Web, SQLcl, or even via #REST APIs.
video chapters
6:40 Demo: Building New tables from CSV/Excel using SQL Devleoper Wizards
19:11 Using SQLDev to help build SQLLDR scenarios
20:18 Demo: Importing data with SQL Developer Web
26:20 One line command: importing CSV using SQLcl
28:37 REST APIs and Loading data
31:32 SQLcl and Data Pump
39:00 Q&A
Additional Resources
11 Tips for importing from Excel
https://www.thatjeffsmith.com/archive...
The Slides
https://speakerdeck.com/thatjeffsmith...
Using SQL Developer to setup CSV to be loaded via SQL*Loader:
https://www.thatjeffsmith.com/archive...
SQLcl and Data Pump:
https://www.thatjeffsmith.com/archive...
Bulk Load an Oracle TABLE using CSV via REST API, HTTPS POST
https://www.thatjeffsmith.com/archive...
