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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial