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 conventionaldirect-pathparallel comparison 1:05:50 Useful links Session links Insert Live SQL Tutorial Tuning Insert Live SQL Tutorial Learn SQL for Free

Источник: rutube.ru