Selasa, 21 Februari 2012

4 new posts


4 new posts

Link to Wow! eBook - Blog

Oracle Essentials: Oracle Database 11g, 4th Edition

Posted: 21 Feb 2012 09:09 AM PST

Oracle Essentials: Oracle Database 11g, 4th Edition

Book Description

is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and administrators-find it difficult to get a handle on the full scope of the . And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle 11g.

This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:

  • Oracle products, options, data structures, and overall for Oracle 11g, as well as earlier releases (Oracle 10g, Oracle9i, and Oracle8i)
  • Installing, running, managing, monitoring, , and tuning Oracle, including Enterprise Manager (EM) and Oracle’s self-tuning and capabilities; and using Oracle , auditing, and compliance (a new chapter in this edition)
  • Multiuser concurrency, data warehouses, distributed databases, transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)
  • Features beyond the : Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a provider

The latest 11g features: query result set caching, Automatic Memory , the Real Application , Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction , transparent data , the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)

For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you’ll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.

Oracle Essentials gives a clear explanation of the key database concepts and underlying the Oracle database. It’s a great reference for anyone doing development or management of Oracle databases.”
–Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

Table of Contents
Chapter 1. Introducing Oracle
Chapter 2. Oracle Architecture
Chapter 3. Installing and Running Oracle
Chapter 4. Oracle Data Structures
Chapter 5. Managing Oracle
Chapter 6. Oracle , Auditing, and Compliance
Chapter 7. Oracle
Chapter 8. Oracle Multiuser Concurrency
Chapter 9. Oracle and Transaction Processing
Chapter 10. Oracle Data Warehousing and Intelligence
Chapter 11. Oracle and High Availability
Chapter 12. Oracle and Hardware Architecture
Chapter 13. Oracle Distributed Databases and Distributed Data
Chapter 14. Oracle Extended Datatypes
Chapter 15. Beyond the Oracle Database

Appendix A. What’s New in This Book for Oracle Database 11g
Appendix B. Additional Resources

Book Details

  • Paperback: 416 pages
  • Publisher: O’Reilly Media; 4th Edition (November 2007)
  • Language: English
  • ISBN-10: 0596514549
  • ISBN-13: 978-0596514549
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Learning Oracle PL/SQL

Posted: 21 Feb 2012 09:02 AM PST

Learning Oracle PL/SQL

Book Description

PL/, ’s language for stored procedures, delivers a world of possibilities for your programs. PL/ supplements the standard relational language, , with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control–all closely integrated with the database server.

Knowing where to start with ’s procedural language is not always obvious to a newcomer, especially considering the language’s feature set and the sheer size of the official documentation (not to mention ’s ever-increasing number of pre-built programs). But Learning Oracle offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials.

Topics include:

  • PL/SQL–what is it, and why use it? Why use PL/SQL instead of ?
  • Syntax and examples of all core language constructs
  • Creating, using, and reusing stored procedures, functions, and packages
  • Building web-based applications using PL/SQL features available “out of the box” (such as PL/ Pages)
  • Securing PL/SQL programs against attack
  • Benefits of third-party developer tools and integrated environments
  • Connecting PL/SQL to email, , and the Internet

Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i.

Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O’Reilly books (such as the bestselling Oracle PL/SQL ) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.

Table of Contents
Chapter 1. PL/SQL: What, When, and Where
Chapter 2. Fundamentals
Chapter 3. Let’s Code!
Chapter 4. Go Web, Young Man
Chapter 5. Fetch!
Chapter 6. Keeping House
Chapter 7. : Keep the Bad Guys Out
Chapter 8. Communicating with the Outside World
Chapter 9. Intermediate Topics and Other Diversions
Chapter 10. Afterword: “Making Good” of Database Programming

Book Details

  • Paperback: 450 pages
  • Publisher: O’Reilly Media (November 2001)
  • Language: English
  • ISBN-10: 0596001800
  • ISBN-13: 978-0596001803
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Oracle PL/SQL Programming: A Developer’s Workbook

Posted: 21 Feb 2012 08:59 AM PST

Oracle PL/SQL Programming: A Developers Workbook

Book Description

However excellent they are, most computer books are inherently passive–readers simply take in text without having any opportunity to react to it. The Developer’s Workbook is a different kind of animal! It’s designed to engage you actively, to get you solving problems immediately, and to help you apply what you’ve learned about –and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you’ll find yourself moving more rapidly along the learning curve to join the growing ranks of experts.

The PL/ Developer’s Workbook is a companion to Steven Feuerstein’s bestselling Oracle PL/ and his other PL/SQL books from O’Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer–both with PL/SQL and with other languages. Exercises are provided at three levels: , intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., and web features, autonomous transactions, and bulk binds).

You’ll find chapters on:

  • Basic language elements–variables, naming, loops, conditional and sequential control, exception handling, and records.
  • Data structures–index-by tables, nested tables, variables arrays (VARRAYs), and object technology.
  • interaction–cursors, DML and transaction , cursor variables, and native dynamic SQL
  • Program construction–procedures, functions, blocks, packages, triggers, and calling PL/SQL functions in SQL.
  • Built-in functionality–the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages.
  • Miscellaneous topics–using with PL/SQL, external programs, PL/SQL web , tuning PL/SQL, and PL/SQL for DBAs.

Table of Contents
Chapter 1. Declaring Variables and Naming Elements
Chapter 2. Loops
Chapter 3. Conditional and Sequential Logic
Chapter 4. Exception Handling
Chapter 5. Records
Chapter 6. Index-by Tables
Chapter 7. Nested Tables
Chapter 8. Variable Arrays
Chapter 9. Object Technology
Chapter 10. Cursors
Chapter 11. DML and Transaction
Chapter 12. Cursor Variables
Chapter 13. Native Dynamic SQL
Chapter 14. Procedures, Functions, and Blocks
Chapter 15. Packages
Chapter 16. Triggers
Chapter 17. Calling Functions in SQL
Chapter 18. Character Functions
Chapter 19. Date Functions
Chapter 20. Conversion, Numeric, and Miscellaneous Functions
Chapter 21. DBMS_SQL Built-in Package
Chapter 22. DBMS_PIPE Built-in Package
Chapter 23. DBMS_OUTPUT Built-in Package
Chapter 24. UTL_FILE Built-in Package
Chapter 25. DBMS_JOB Built-in Package
Chapter 26. Using Java with PL/SQL
Chapter 27. External Procedures
Chapter 28. PL/SQL Web
Chapter 29. Tuning PL/SQL
Chapter 30. PL/SQL for DBAs

Book Details

  • Paperback: 592 pages
  • Publisher: O’Reilly Media (May 2000)
  • Language: English
  • ISBN-10: 1565926749
  • ISBN-13: 978-1565926745
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Oracle SQL*Loader: The Definitive Guide

Posted: 21 Feb 2012 08:53 AM PST

Oracle SQL*Loader: The Definitive Guide

Book Description

Loader is a ubiquitous tool in the world. It has been shipped with since at least Version 6 and continues to be supported and enhanced with each new version of , including 8 and 8i. The job of Loader is to load data from flat files into an . It’s optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.

Almost every user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader’s wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: has everything you need to know to put to its best use: an introduction to SQLLoader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQLLoader tasks you’d want to perform–and maybe some you didn’t realize you COULD perform.

You’ll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You’ll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQLLoader by adjusting the transaction size and using the new direct path option. It also covers the newest SQLLoader features–the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).

Oracle SQLLoader: is an indispensable resource for anyone who is new to ; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.

Table of Contents
Chapter 1. Introduction to SQL*Loader
Chapter 2. The Mysterious Control File
Chapter 3. Fields and Datatypes
Chapter 4. Loading from Fixed-Width Files
Chapter 5. Loading Delimited Data
Chapter 6. Recovering from Failure
Chapter 7. Validating and Selectively Loading Data
Chapter 8. Transforming Data During a Load
Chapter 9. Transaction Size and Issues
Chapter 10. Direct Path Loads
Chapter 11. Loading Large Objects
Chapter 12. Loading Objects and Collections

Book Details

  • Paperback: 272 pages
  • Publisher: O’Reilly Media (April 2001)
  • Language: English
  • ISBN-10: 1565929489
  • ISBN-13: 978-1565929487
Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts


Tidak ada komentar:

Posting Komentar