O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

4

The SELECT Statement

In this chapter:

  • How do you write a basic query using SELECT statements?

  • What types of SELECT statements are possible?

  • What else is interesting about SELECT statements?

In this chapter, we dive right into the syntax and use of the SELECT statement to query the database. We also briefly discuss different types of queries, finally examining specific aspects of queries such as using DISTINCT and the DUAL table. So let’s begin with the basics of the SELECT statement and some simple examples just to get into the swing of things.

4.1 The Basic SELECT Statement

SELECT is the beginning of the SQL command for querying (retrieving) data from a database table, view, or object. Objects are similar to tables, but they have a more ...

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