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. ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.