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