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

Certification objectives covered

In this section, we have seen the following certification objectives covered:

  • Limiting the rows that are retrieved by a query
  • Sorting the rows that are retrieved by a query
  • Using ampersand substitution to restrict and sort output at runtime

Up to this point, we've focused almost exclusively on ways to retrieve data from database tables. In the next chapter, we'll add a completely new dimension to our SQL abilities—the ability to manipulate the data in existing tables. We'll learn how to add rows to a table, to change data in tables, and to delete data from tables.

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