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

Retrieving data with SELECT statements

One of the most important operations done while connected to a database is the query. In database terms, a query is a request to retrieve data from a database table or tables. Queries can range in complexity from simple queries, consisting of a few lines, to extremely long and intricate reports composed of pages of code. Queries form the backbone of business reporting and, as such, are a vital part of the SQL language. We compose queries using the SELECT statement, as discussed in this section.

Projecting columns in a SELECT statement

Now that we have laid out some of the syntactical rules for SQL statements, it is time to learn about the structure of our first SQL statement. We see what is commonly referred ...

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