Pro Oracle SQL pp 283-324 | Cite as

Subquery Factoring

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

Abstract

You may not be familiar with the term subquery factoring. Prior to the release of Oracle 11gR2, the official Oracle documentation barely mentions it, providing just a brief synopsis of its use, a couple of restrictions, and a single example. If I instead refer to the WITH clause of the SELECT statement, you will probably know immediately what I mean as this term is more recognizable. Both terms will be used in this chapter.

Keywords

Shipping Income Gravel Argentina 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