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...
Nesta página do site você pode assistir ao vídeo on-line Loading Data Into Your Database Tips & Tricks duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Jeff Smith 28 Março 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 2,745 vezes e gostou 40 espectadores. Boa visualização!
