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...
On this page of the site you can watch the video online Loading Data Into Your Database Tips & Tricks with a duration of hours minute second in good quality, which was uploaded by the user Jeff Smith 28 March 2022, share the link with friends and acquaintances, this video has already been watched 2,745 times on youtube and it was liked by 40 viewers. Enjoy your viewing!
