Chapter 1. Introducing SQL

ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Retrieving Data Using the SQL SELECT Statement

    • List the capabilities of SQL SELECT statements

    • Execute a basic SELECT statement

  • Restricting and Sorting Data

    • Limit the rows that are retrieved by a query

    • Sort the rows that are retrieved by a query

    • Use ampersand substitution to restrict and sort output at runtime

Introducing SQL

Oracle 11g is a very powerful and feature-rich relational database management system (RDBMS). SQL has been adopted by most RDBMSs for the retrieval and management of data, schema creation, and access control. The American National Standards Institute ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with O’Reilly online learning.

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