O'Reilly logo

Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) by Gavin Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Changing Data (DML)

Terms You Need to Understand

  • ✓ Data Manipulation Language (DML)

  • ✓ Data Definition Language (DDL)

  • DEFAULT

  • INSERT

  • UPDATE

  • DELETE

  • TRUNCATE

  • MERGE

  • ✓ Transaction

  • COMMIT

  • ROLLBACK

  • SAVEPOINT

Concepts You Need to Master

  • ✓ Single table INSERT

  • ✓ Multiple table INSERT

  • ✓ Default values

  • ✓ Transactional control

  • ✓ Transactions and consistency of data

  • ✓ Transactions and DDL commands

This chapter describes how to change data in an Oracle database, concluding with details on transactional control. Transactional control is most important to user concurrency and maintaining consistency of data in a database.

What Is the Difference Between DML and DDL?

Data Manipulation Language (DML) implies manipulation of and changes to data in a database. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required