Help Section
Lab #8: Insert data from queries
Learn how to use an INSERT statement with a query of other data and an embedded sequence value. Reinforce how to alter a table’s column to add a NOT NULL constraint, update a column with a correlated UPDATE statement, learn how to use a correlated UPDATE statement to set an initial value in a newly added column.
- Lab
- Description
- Help Section
- Instructions
Help Section
The following reading and articles are important preparation for this lab. Please make sure you read them and understand the concepts and techniques in them.
