Skip to Main Content

Write Great SQL Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

May 18

13:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Description

All about insert - Back to basics
You use the INSERT statement to load data into a database. In this session, we looked at how to:

- Do single and multi-row inserts
- Simplify code with record inserts
- Set default values for columns and return their values
- Load data into many tables in one statement
- Insert data faster

Highlights of this session are:

00:50 Basic insert statement
02:05 Inserts without column lists
05:20 Record-based inserts with %rowype
06:25 When default values are assigned
08:10 Override null values on insert with the default
09:40 Demo - default values; building insert APIs
15: 30 Inserts with invisible columns
16:40 Virtual columns
17:45 Inserting into views
19:15 Inserting into view with where clauses
21:45 Inserting into views with many tables
26:20 Demo of inserts with invisible and virtual columns
27:50 Demo of inserts into views
37:00 Inserting the result of a query
39:30 Multi-table inserts
44:50 Demo of multi-row and multi-table inserts
49:10 Tuning insert statements
51:10 Direct-path loads
52:10 Performance comparison demos
58:50 Summary
1:01:20 Performance results of conventional/direct-path/parallel comparison
1:05:50 Useful links

Session links

Insert Live SQL Tutorial https://bit.ly/insert-tutorial

Tuning Insert Live SQL Tutorial https://bit.ly/tuning-insert-tutorial

Learn SQL for Free http://bit.ly/learn-sql-free-dfd-f

Your Experts

Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.