How long will the script take to run?
In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,
Tag: insert
Combinations and consequences
Fellow Perth techie Scott Wesley sent me this interesting puzzle recently. He was using the long awaited feature of being
Generating INSERT scripts that run fast!
Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or
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
Multi-table insert
An interesting question came through on AskTom recently. The requirement was to perform a single pass through a source table,
Learning is not a spectator sport 