O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

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

Making a Simple Database Query

In Chapter 1, we saw that an entity’s attributes are contained in a set of related tables. Each table contains records (or instances) about the entity. Each record is composed of related sets of attributes about the entity. In order to produce information about the entity, the attribute values must be retrieved from the database tables in which they reside. This is done using an SQL command called a SELECT statement, which is a powerful tool for extracting attributes from a database and producing information.

SELECT statements contain six clauses:

•SELECT Identifies the attributes retrieved from the database
•FROM Identifies the table(s) that contains the attributes
•WHERE Contains conditions used to identify ...

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