没有合适的资源?快使用搜索试试~ 我知道了~
首页Apress - Oracle SQL Recipes A Problem Solution Approach (November 2009) (ATTiCA).pdf
资源详情
资源评论
资源推荐
this print for content only—size & color not accurate spine = x.xxx" xxx page count
Allen
Bryla
Kuhn
Oracle SQL Recipes
The eXPeRT’s VOIce
®
In ORacle
Oracle SQL
Recipes
A Problem-Solution Approach
cYan
MaGenTa
YellOW
BlacK
PanTOne 123 c
Grant Allen, Bob Bryla,
Darl Kuhn
Companion
eBook Available
An example-based approach to solving
common developer and administration
problems with Oracle SQL
BOOKs fOR PROfessIOnals BY PROfessIOnals
®
Oracle SQL Recipes:
A Problem-Solution Approach
Dear Reader,
Oracle SQL Recipes is designed to feed your appetite for solutions to all manner of
query problems working with data in Oracle. If you’ve ever struggled to report on
data using SQL alone, or marveled at the elegant and skillful way some write SQL
for Oracle to solve seemingly intractable problems, you’ll want to delve into this
book, as it will show you the techniques for creating queries like a pro.
Using this book, you’ll learn the many intricacies of SQL in Oracle, and
the sheer power and features that are at your command to tackle problems as
diverse as statistical modeling, multi-level financial reports, and even dynami-
cally generating web pages directly from your database using just SQL. Each
issue we tackle is presented in problem/solution format. First we state a prob-
lem to be solved. Then we show the solution in SQL. Lastly, we discuss in detail
any caveats you need to know, as well as why the solution works. Oracle SQL
Recipes is suitable for readers at any level of SQL proficiency, and includes reci-
pes to expand the skills of SQL aficionados from beginner all the way through
to seasoned experts.
Whether you are a user of the data in an Oracle database, an application
developer, or a DBA, there are topics in this book to cater to your needs. We’re
excited to present you with this collection of recipes. As authors, we wrote this
book to highlight the power and capability of SQL within Oracle, and how it can
solve many of the problems that are often deemed too difficult to write outside
of application code. Armed with the knowledge herein, you’ll master the latest
and greatest Oracle database capabilities, and be improvising your own recipes
in no time. We hope you find the recipes fit many of the real-world problems
you encounter working with Oracle and SQL every day, and look forward to see-
ing the recipes you create from this inspiration.
Grant Allen, Bob Bryla, Darl Kuhn
US $49.99
Shelve in
Databases/Oracle
User level:
Beginner–Advanced
THE APRESS ROADMAP
Troubleshooting
Oracle Performance
Oracle SQL Recipes
Beginning
Oracle SQL
www.apress.com
Companion eBook
See last page for details
on $10 eBook version
)3".
Darl Kuhn author of
Linux Recipes for
Oracle DBAs
Grant Allen author of
Beginning DB2
Bob Bryla author of
Beginning PHP and Oracle
this print for content only—size & color not accurate spine = x.xxx" xxx page count
Allen
Bryla
Kuhn
Oracle SQL Recipes
The eXPeRT’s VOIce
®
In ORacle
Oracle SQL
Recipes
A Problem-Solution Approach
cYan
MaGenTa
YellOW
BlacK
PanTOne 123 c
Grant Allen, Bob Bryla,
Darl Kuhn
Companion
eBook Available
An example-based approach to solving
common developer and administration
problems with Oracle SQL
BOOKs fOR PROfessIOnals BY PROfessIOnals
®
Oracle SQL Recipes:
A Problem-Solution Approach
Dear Reader,
Oracle SQL Recipes is designed to feed your appetite for solutions to all manner of
query problems working with data in Oracle. If you’ve ever struggled to report on
data using SQL alone, or marveled at the elegant and skillful way some write SQL
for Oracle to solve seemingly intractable problems, you’ll want to delve into this
book, as it will show you the techniques for creating queries like a pro.
Using this book, you’ll learn the many intricacies of SQL in Oracle, and
the sheer power and features that are at your command to tackle problems as
diverse as statistical modeling, multi-level financial reports, and even dynami-
cally generating web pages directly from your database using just SQL. Each
issue we tackle is presented in problem/solution format. First we state a prob-
lem to be solved. Then we show the solution in SQL. Lastly, we discuss in detail
any caveats you need to know, as well as why the solution works. Oracle SQL
Recipes is suitable for readers at any level of SQL proficiency, and includes reci-
pes to expand the skills of SQL aficionados from beginner all the way through
to seasoned experts.
Whether you are a user of the data in an Oracle database, an application
developer, or a DBA, there are topics in this book to cater to your needs. We’re
excited to present you with this collection of recipes. As authors, we wrote this
book to highlight the power and capability of SQL within Oracle, and how it can
solve many of the problems that are often deemed too difficult to write outside
of application code. Armed with the knowledge herein, you’ll master the latest
and greatest Oracle database capabilities, and be improvising your own recipes
in no time. We hope you find the recipes fit many of the real-world problems
you encounter working with Oracle and SQL every day, and look forward to see-
ing the recipes you create from this inspiration.
Grant Allen, Bob Bryla, Darl Kuhn
US $49.99
Shelve in
Databases/Oracle
User level:
Beginner–Advanced
THE APRESS ROADMAP
Troubleshooting
Oracle Performance
Oracle SQL Recipes
Beginning
Oracle SQL
www.apress.com
Companion eBook
See last page for details
on $10 eBook version
)3".
Darl Kuhn author of
Linux Recipes for
Oracle DBAs
Grant Allen author of
Beginning DB2
Bob Bryla author of
Beginning PHP and Oracle
Oracle SQL Recipes
A Problem-Solution Approach
■ ■ ■
Grant Allen, Bob Bryla, and Darl Kuhn
ii
Oracle SQL Recipes: A Problem-Solution Approach
Copyright © 2009 by Grant Allen, Bob Bryla, and Darl Kuhn
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-2509-6
ISBN-13 (electronic): 978-1-4302-2510-2
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a
trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no
intention of infringement of the trademark.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewer: Stephane Faroult
Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Tony Campbell, Gary
Cornell, Jonathan Gennick, Michelle Lowman, Matthew Moodie, Jeffrey Pepper, Frank Pohlmann, Ben
Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Coordinating Editor: Debra Kelly
Copy Editor: Sharon Terdeman
Compositor: LaurelTech
Indexer: Becky Hornyak
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor, New York,
NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com, or visit
http://www.springeronline.com.
For information on translations, please e-mail info@apress.com, or visit http://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 http://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.
To George, for teaching me everything he knows.
–Grant
To the gang at home, even with my long hours I was still able to make the football, volleyball, and
basketball games!
–Bob
To Heidi, Brandi, and Lisa.
–Darl
剩余577页未读,继续阅读
angelzhanmaster
- 粉丝: 0
- 资源: 39
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论2