- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
This item may be
Check for Availability
Oracle PL/SQL Programming
Synopses & Reviews
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.
Book News Annotation:
The definitive reference on PL/SQL rolls into its fifth edition, updated to include versions through Oracle Database 11g release 2. Material in the book ranges from the fundamentals of the Oracle language to advanced coding techniques and best practices. The book also discusses new PL/SQL features and provides extensive code samples (some of which are on the book's companion website). This is an ideal reference for both novice users and experienced programmers. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)
Thoroughly updated for Oracle Database 11gR2, this book has been the leading reference on Oracle's powerful procedural language for more than a decade. Through 12 years and four previous editions, this comprehensive guide has a long heritage of solid technical content, community admiration, and sales. Like its predecessors, the updated fifth edition contains language syntax, features, best practices, and optimization advice. It provides extensive code, ranging from simple examples to complex and complete real applications.
Every action in SQL Server - queries, updates, whatever - leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performance of queries and better understand what's really going on inside a SQL Server system
SQL Server DMVs in Action is a practical guide that shows how to obtain, interpret, and act on the information captured by DMVs to keep SQL Server in top shape. The 100+ samples provided in this book will help readers master DMVs and also give them a tested, working, and instantly reusable SQL code library.
About the Author
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.
Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.
Table of Contents
Dedication Preface Programming in PL/SQL Chapter 1: Introduction to PL/SQL Chapter 2: Creating and Running PL/SQL Code Chapter 3: Language Fundamentals PL/SQL Program Structure Chapter 4: Conditional and Sequential Control Chapter 5: Iterative Processing with Loops Chapter 6: Exception Handlers PL/SQL Program Data Chapter 7: Working with Program Data Chapter 8: Strings Chapter 9: Numbers Chapter 10: Dates and Timestamps Chapter 11: Records Chapter 12: Collections Chapter 13: Miscellaneous Datatypes SQL in PL/SQL Chapter 14: DML and Transaction Management Chapter 15: Data Retrieval Chapter 16: Dynamic SQL and Dynamic PL/SQL PL/SQL Application Construction Chapter 17: Procedures, Functions, and Parameters Chapter 18: Packages Chapter 19: Triggers Chapter 20: Managing PL/SQL Code Chapter 21: Optimizing PL/SQL Performance Chapter 22: I/O and PL/SQL Advanced PL/SQL Topics Chapter 23: Application Security and PL/SQL Chapter 24: PL/SQL Architecture Chapter 25: Globalization and Localization in PL/SQL Chapter 26: Object-Oriented Aspects of PL/SQL Chapter 27: Calling Java from PL/SQL Chapter 28: External Procedures Regular Expression Metacharacters and Function Parameters Number Format Models Date Format Models Colophon
What Our Readers Are Saying
Computers and Internet » Computer Languages » SQL