Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: insert
Hacking together faster INSERTs
Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or Excel, and some even allow you to unload the data as INSERT statements. The latter is pretty cool because it’s a nice way of…
Partition loading in direct mode
Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into a table very quickly and efficiently. Obviously there are a number of implications of doing so which you can read about here, but the…
Multi-table insert
An interesting question came through on AskTom recently. The requirement was to perform a single pass through a source table, and load the data into three target tables. Now that’s trivially achieved with a multi-table insert, but there was a subtle “twist” on this…
