Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | December 3, 2014

    Mary Oliver: IMG Mary Oliver: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Oracle PL/SQL Programming

Oracle PL/SQL Programming Cover

 

Synopses & Reviews

Publisher Comments:

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.

This indispensable reference for both novices and experienced Oracle programmers will help you:

  • Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
  • Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
  • Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
  • Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
  • Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
  • Build modular PL/SQL applications using procedures, functions, triggers, and packages

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)

Synopsis:

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.

Synopsis:

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

Product Details

ISBN:
9780596514464
Subtitle:
Covers Versions Through Oracle Database 11g Release 2
Publisher:
O'Reilly Media
With:
Pribyl, Bill
Author:
Pribyl, Bill
Author:
ribyl, Bill
Author:
Feuerstein, Steven
Author:
P.
Author:
Stirk, Ian W.
Subject:
Programming Languages - SQL
Subject:
Database Management - Oracle
Subject:
Relational databases
Subject:
PL/SQL (Computer program language)
Subject:
Database Management - General
Subject:
Computer Languages-SQL
Subject:
Oracle;database;developer;programmer;software engineering
Subject:
CourseSmart Subject Description
Edition Description:
Fifth Edition
Series:
Animal Guide
Publication Date:
20091004
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
1232
Dimensions:
9.25 x 7.38 in

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Oracle PL/SQL Programming
0 stars - 0 reviews
$ In Stock
Product details 1232 pages O'Reilly Media - English 9780596514464 Reviews:
"Synopsis" by ,
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.
"Synopsis" by ,

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.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.