Murach's Oracle SQL and PL/SQL
How to insert, update, and delete data

This chapter teaches you how to code queries to modify the data in a table using the SQL INSERT, UPDATE, and DELETE statements.
Chapter 7 How to insert, update, and delete data
How to create test tables 212
How to create the tables for this book 212
How to create a copy of a table 212
How to commit and rollback changes 214
How to commit changes 214
How to rollback changes 214
How to insert new rows 216
How to insert a single row 216
How to insert default values and null values 218
How to use a subquery to insert multiple rows 220
How to update existing rows 222
How to update rows 222
How to use a subquery in an UPDATE statement 224
How to delete existing rows 226
How to delete rows 226
How to use a subquery in a DELETE statement 226


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.