Skip to Main Content

Session

Session

External Tables – So Much More than SQL*Loader

External tables arrived with a "So what?" response. After all, they replicated functionality that had already been available for decades with SQL*Loader. But external tables are definitely not just your everyday data loader. Each release of the Oracle Database adds to their functionality, and nowadays, the list of tasks you can do with external tables is mind-blowing.

In this session, you will see how they have evolved through the various releases of the Oracle Database, and then we'll take external table usage to another level. For example, using them to load XLSX spreadsheets, monitor your database instance, run OS utilities from within the database, or even update the Oracle software on the fly!
Dallas 5
June 22nd 03:30 PM
June 22nd 04:30 PM
Core & Database
Tools
Solutions
Backend Developer, Database Administrator
Beginner, On-prem, Cloud

About the speaker:

Connor McDonald
Database Advocate
Oracle Corporation

Connor McDonald is a database advocate for Oracle Corporation. Ever frustrated as a child with the limits imposed by the single kilobyte of RAM in his Sinclair ZX80 computer, he has loved the challenges that come with storing data, which ultimately led to a career in database technology. When the infamous Y2K data issue did not end the world as people thought, he started presenting on his database passions, found that he loved doing it, and has spoken at over 120 conferences around the world since then. Due to his partner’s predilection for rescuing stray cats, he doesn’t just speak the phrase "it’s like herding cats", he lives it every day.