O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Summary

In this chapter, we've added the power of DML to our SQL abilities. We learned to add, modify, and remove data from relational tables using INSERT, UPDATE, and DELETE. We've learned the importance of adding limiting conditions to our UPDATE and DELETE statements. We've learned about the concept of transactions and used COMMIT, ROLLBACK, and SAVEPOINT to achieve transaction control. Lastly, we've looked at the types of error messages generated by Oracle.

Certification objectives covered

  • Describe each data manipulation language (DML) statement
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

At this point in the book, we've learned the basics of retrieving and manipulating data with SQL statements. However, ...

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