The Fictioning Horror Sale
 
 

Recently Viewed clear list


Interviews | September 2, 2014

Jill Owens: IMG David Mitchell: The Powells.com Interview



David MitchellDavid Mitchell's newest mind-bending, time-skipping novel may be his most accomplished work yet. Written in six sections, one per decade, The Bone... Continue »
  1. $21.00 Sale Hardcover add to wish list

    The Bone Clocks

    David Mitchell 9781400065677

spacer
Qualifying orders ship free.
$34.00
List price: $69.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Partner Warehouse Database- SQL

Oracle PL/SQL Programming (5TH 10 - Old Edition)

by

Oracle PL/SQL Programming (5TH 10 - Old Edition) Cover

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

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
Author:
Feuerstein, Steven
With:
Pribyl, Bill
Author:
P.
Author:
Stirk, Ian W.
Author:
Pribyl, Bill
Author:
ribyl, Bill
Author:
Feuerstein, Steven
Publisher:
O'Reilly Media
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

Other books you might like

  1. Colloquial Chinese Mandarin: The... New Trade Paper $35.95
  2. Serge with Confidence Used Trade Paper $14.95
  3. Murder by High Tide (Gil Jordan) Used Hardcover $17.95
  4. The World of Mathematics Set New Trade Paper $64.75
  5. The Encyclopedia of Earth: A...
    Used Hardcover $30.00
  6. Reality Hunger: A Manifesto Used Trade Paper $8.95

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 (5TH 10 - Old Edition) Used Trade Paper
0 stars - 0 reviews
$34.00 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.