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