Pro Oracle SQL - Morton_ Karen.pdf

(6544 KB) Pobierz
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
THE EXPERT’S VOICE ® IN ORACLE
Pro
Oracle SQL
Exploit the full power of SQL and
supporting features in Oracle Database
Karen Morton, Kerry Osborne, Robyn Sands
Riyaj Shamsudeen, and Jared Still
878805346.099.png
 
 
 
 
 
 
 
 
878805346.050.png 878805346.060.png 878805346.071.png 878805346.074.png 878805346.075.png 878805346.076.png 878805346.077.png 878805346.078.png 878805346.079.png 878805346.080.png 878805346.081.png 878805346.082.png 878805346.083.png 878805346.084.png 878805346.085.png 878805346.086.png 878805346.087.png 878805346.088.png 878805346.089.png 878805346.090.png 878805346.091.png 878805346.092.png 878805346.093.png 878805346.094.png 878805346.095.png 878805346.096.png
 
878805346.097.png 878805346.098.png
 
 
 
 
 
 
 
 
 
 
 
 
878805346.100.png
 
 
 
878805346.101.png 878805346.102.png 878805346.103.png 878805346.104.png 878805346.105.png 878805346.106.png 878805346.107.png 878805346.108.png 878805346.109.png 878805346.110.png 878805346.111.png 878805346.112.png 878805346.113.png
 
878805346.114.png
 
878805346.115.png
 
878805346.116.png
 
878805346.117.png
 
878805346.118.png 878805346.119.png 878805346.120.png 878805346.121.png 878805346.122.png 878805346.123.png 878805346.124.png 878805346.001.png 878805346.002.png 878805346.003.png 878805346.004.png
 
878805346.005.png 878805346.006.png 878805346.007.png 878805346.008.png 878805346.009.png 878805346.010.png 878805346.011.png 878805346.012.png 878805346.013.png 878805346.014.png 878805346.015.png 878805346.016.png 878805346.017.png 878805346.018.png 878805346.019.png 878805346.020.png 878805346.021.png 878805346.022.png 878805346.023.png 878805346.024.png 878805346.025.png 878805346.026.png 878805346.027.png 878805346.028.png 878805346.029.png 878805346.030.png 878805346.031.png 878805346.032.png 878805346.033.png 878805346.034.png 878805346.035.png 878805346.036.png 878805346.037.png 878805346.038.png 878805346.039.png 878805346.040.png 878805346.041.png 878805346.042.png 878805346.043.png 878805346.044.png 878805346.045.png 878805346.046.png 878805346.047.png 878805346.048.png 878805346.049.png 878805346.051.png 878805346.052.png 878805346.053.png 878805346.054.png 878805346.055.png 878805346.056.png 878805346.057.png
 
Pro Oracle SQL
Karen Morton
Kerry Osborne
Robyn Sands
Riyaj Shamsudeen
Jared Still
878805346.058.png 878805346.059.png 878805346.061.png 878805346.062.png 878805346.063.png 878805346.064.png 878805346.065.png
Pro Oracle SQL
Copyright © 2010 by Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen,
and Jared Still
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any
means, electronic or mechanical, including photocopying, recording, or by any information
storage or retrieval system, without the prior written permission of the copyright owner and the
publisher.
ISBN-13 (pbk): 978-1-4302-3228-5
ISBN-13 (electronic): 978-1-4302-3229-2
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names, logos, and images may appear in this book. Rather than use a trademark
symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and
images only in an editorial fashion and to the benefit of the trademark owner, with no intention of
infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if
they are not identified as such, is not to be taken as an expression of opinion as to whether or not
they are subject to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewers: Christopher Beck, Iggy Fernandez, and Bernard Lopuz
Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell,
Jonathan Gennick, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes,
Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic
Shakeshaft, Matt Wade, Tom Welsh
Coordinating Editor: Anita Castro
Copy Editor: Mary Behr
Compositor: Lynn L'Heureux
Indexer: Julie Grady
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media, LLC.,
233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505,
For information on translations, please e-mail rights@apress.com , or visit www.apress.com .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional
use. eBook versions and licenses are also available for most titles. For more information, reference
our Special Bulk Sales–eBook Licensing web page at www.apress.com/info/bulksales .
The information in this book is distributed on an “as is” basis, without warranty. Although every
precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall
have any liability to any person or entity with respect to any loss or damage caused or alleged to be
caused directly or indirectly by the information contained in this work.
Contents at a Glance
About the Authors ................................................................................................................ xv
About the Technical Reviewer........................................................................................... xvii
Introduction......................................................................................................................... xix
Chapter 1: Core SQL ............................................................................................................... 1
Chapter 2: SQL Execution .................................................................................................... 29
Chapter 3: Access and Join Methods.................................................................................. 61
Chapter 4: SQL is About Sets............................................................................................. 105
Chapter 5: It’s About the Question .................................................................................... 129
Chapter 6: SQL Execution Plans ........................................................................................ 153
Chapter 7: Advanced Grouping.......................................................................................... 191
Chapter 8: Analytic Functions ........................................................................................... 221
Chapter 9: The Model Clause............................................................................................. 251
Chapter 10: Subquery Factoring........................................................................................ 283
Chapter 11: Semi-joins and Anti-joins .............................................................................. 325
Chapter 12: Indexes ........................................................................................................... 373
Chapter 13: Beyond the SELECT ........................................................................................ 403
Chapter 14: Transaction Processing ................................................................................. 433
Chapter 15: Testing and Quality Assurance...................................................................... 465
Chapter 16: Plan Stability and Control .............................................................................. 497
Index................................................................................................................................... 565
878805346.066.png 878805346.067.png 878805346.068.png 878805346.069.png 878805346.070.png 878805346.072.png 878805346.073.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin