Abstract
This chapter discusses a selection of fairly independent SQL features that are of importance for the tuning process, many of which are somewhat poorly advertised. I’ll begin with a quick review of just what SQL statements are and the identifiers used to refer to them. My second topic is the array interface that is used to move data from client processes to the database server in large batches. I will then discuss factored subqueries that make reading SQL statements much easier. My fourth and final topic in this first chapter is a review of the different types of inner and outer joins; I will explain how to write them, what they are used for, and why it isn’t quite as easy to reorder outer joins as it is to reorder inner joins.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Tony Hasler
About this chapter
Cite this chapter
Hasler, T. (2014). SQL Features. In: Expert Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5978-7_1
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5978-7_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-5977-0
Online ISBN: 978-1-4302-5978-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books