Pro Oracle SQL pp 105-128 | Cite as

SQL is About Sets

  • Karen Morton
  • Kerry Osborne
  • Robyn Sands
  • Riyaj Shamsudeen
  • Jared Still

Abstract

One of the most difficult transitions to make in order to become highly proficient at writing SQL well is to shift from thinking procedurally to thinking declaratively (or in sets). It is often hardest to learn to think in sets if you’ve spent time working with virtually any programming language. Ifthisisthe case for you, you are likely very comfortable with constructs such as IF-THEN-ELSE, WHILE-DO, LOOP-END LOOP, and BEGIN-END. These constructs support working with logic and data in a very procedural, step-by-step, top-down type approach. The SQL language is not intended to be implemented from a procedural point of view, but from a set-oriented one. The longer it takes you to shift to a set-oriented point of view, the longer it will be before you are truly proficient at writing SQL that is functionally correct and also highly optimized to perform well.

Keywords

Sorting Karen 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, and Jared Still 2010

Authors and Affiliations

  • Karen Morton
  • Kerry Osborne
  • Robyn Sands
  • Riyaj Shamsudeen
  • Jared Still

There are no affiliations available

Personalised recommendations