Oracle Pl Sql

CYAN
MAGENTA

YELLOW
BLACK
PANTONE 123 C

BOOKS FOR PROFESSIONALS BY PROFESSIONALS ®
Karen Morton, Author of
Expert Oracle Practices
Beginning Oracle SQL

Robyn Sands, Author of
Expert Oracle Practices

Riyaj Shamsudeen,
Author of
Expert Oracle Practices

Companion
eBook Available

Pro Oracle SQL
Pro Oracle SQL unlocks the power of SQL in the Oracle Database—one of themost potent SQL implementations on the market today. To master it requires
a three-pronged approach: learn the language features, learn the supporting
features that Oracle provides to help use the language effectively, and learn to
think and work in sets.
Karen Morton and her team help you master powerful aspects of Oracle
SQL not found in competing databases. You’ll learn analytic functions,the
MODEL clause, and advanced grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro
Oracle SQL also helps you minimize parsing overhead, read execution plans,
test for correct results, and exert control over SQL execution in your database.
You’ll learn when to create indexes, how to verify that they make a difference,
how touse SQL Profiles to optimize SQL in packaged applications, and much
more. You’ll also understand how SQL is optimized for working in sets, and
that the key to getting accurate results lies in making sure that queries ask
clear and precise questions.
• Endorsed by the OakTable Network, a group of Oracle technologists
well-known for their rigorous and scientific approach to Oracle Databaseperformance.
• Comprehensive – goes beyond the language with a focus on what you need
to know to write successful queries and data manipulation statements.

Jared Still

THE APRESS ROADMAP
Beginning
Oracle SQL

Pro
Oracle SQL

Troubleshooting
Oracle Performance

Beginning
Oracle PL/SQL

Oracle PL/SQL
Recipes

Expert
Oracle Database
Architecture

Companion eBook

ProOracle SQL

Kerry Osborne

THE EXPERT’S VOICE ® IN ORACLE

Pro

Oracle SQL
Exploit the full power of SQL and
supporting features in Oracle Database

See last page for details
on $10 eBook version

www.apress.com

ISBN 978-1-4302-3228-5
5 49 9 9

US $49.99

Morton
Osborne
Sanda
Shamsudeen
Still

SOURCE CODE ONLINE

Karen Morton, Kerry Osborne, Robyn Sands
RiyajShamsudeen, and Jared Still

Shelve in:
Databases / Oracle
User level:
Intermediate–Advanced

9 7814
30 232285

this print for content only—size & color not accurate

7.5 x 9.25 spine = 1.125" 600 page count

Download from Wow! eBook

Pro Oracle SQL

Karen Morton
Kerry Osborne
Robyn Sands
Riyaj Shamsudeen
Jared Still

Pro Oracle SQL
Copyright © 2010 by Karen Morton, KerryOsborne, 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 ofthe 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...