Oracle-Books.com
Home > Publisher > Apress
Oracle Books Expert Oracle Application Express
By: Dietmar Aust, Martin Giffy D'Souza, Doug Gault, Dimitri Gielis, Roel Hartman, Michael Hichwa, Sharon Kennedy, ...
Paperback: 500 pages (May 16, 2011)
Apress

Expert Oracle Application Express brings you groundbreaking insight into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful, PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousa nds of concurrent users. The fourteen authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product sing, to develop secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the hard problems surrounding scalability, globalization, configuration and lifecycle management, and more. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally, in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development.


Oracle Books Beginning Oracle Application Express 4
By: Doug Gault, Karen Cannell, Patrick Cimolini, Martin Giffy D'Souza, Timothy St. Hilaire
Paperback - 300 pages (March 31, 2011)
Apress

Beginning Oracle Application Express 4 introduces one of the most talked about development platforms to come out of Oracle Corporation in years. Oracle Application Express, called APEX for short, enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4 brings a huge leap forward in terms of functionality and usability for both the developer and the end user. Power users and programmers alike can quickly put together robust and scal able applications for use by one person, by a department, by an entire company. Whether you're new to Oracle or an old hand who's yet to test the waters of APEX, Beginning Oracle Application Express 4 introduces the processes and best practices you'll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. While the book assumes a fo undational knowledge of SQL and PL/SQL, all code used is documented and explained so that those new to the languages will not be lost.


Oracle Books Pro Data Backup and Recovery
By: Steven Nelson
Paperback: 296 pages (February 24, 2011)
Apress

Good backup and recovery strategies are key to the health of any organization. Medium- to very-large-scale systems administrators have to protect large amounts of critical data as well as design backup solutions that are scalable and optimized to meet changing conditions. Pro Data Backup and Recovery will cover some of the more common backup applications, such as Symantec NetBackup/BackupExec, EMC NetWorker, and CommVault, but the main discussion will focus on the implementation of 21st century architectures that allow the backup software to be a “commodity” item. The underlying architecture provides the framework for meeting the requirements of data protection for the organization. This book covers new developments in data protection as well as the impact of single-instance storage upon backup infrastructures. It discusses the impact of backup and data replication, the often misapplied B2D and D2D strategies, and “tapeless” backup environments. Continuous data protection and remote r eplication strategies are also addressed as they are integrated within backup strategies—a very important topic today.


Oracle Books Pro Oracle Database 11g Administration (Expert's Voice in Oracle)
By: Darl Kuhn
Paperback: 720 pages (December 29, 2010)
Apress

Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle DBA. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself t o the level of Professional Oracle Database Administrator.


Oracle Books Beginning Oracle SQL
By: Lex deHaan, Karen Morton, Tim Gorman, Inger Jørgensen, Daniel Fink
Paperback: 459 pages (December 21, 2010)
Apress

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting resul ts from Oracle Database.


Oracle Books Pro Oracle SQL (Expert's Voice in Oracle)
By: Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
Paperback: 600 pages (December 15, 2010)
Apress

Pro Oracle SQL unlocks the power of SQL in the Oracle Database—one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You'll learn analytic functions, the MODEL clause, and advance d grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions.


Oracle Books Oracle PL/SQL Recipes: A Problem-Solution Approach
By: Josh Juneau, Matt Arena
Electronic: 456 pages (December 9, 2010)
Apress

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner. Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy profess ional who just needs to get the job done.


Oracle Books Oracle PL/SQL Recipes: A Problem-Solution Approach [Kindle Edition]
By: Josh Juneau, Matt Arena
Electronic: 456 pages (December 9, 2010)
Apress

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner. Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy profess ional who just needs to get the job done.


Oracle Books Pro Oracle Database 11g RAC on Linux
By: Martin Bach, Steve Shaw
Paperback: 840 pages (September 30, 2010)
Apress

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance feat ures that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot perform ance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation.


Oracle Books Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
By: Thomas Kyte
Paperback: 832 pages (July 26, 2010)
Apress

Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information managem ent problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.


Oracle Books Expert Oracle Practices: Oracle Database Administration from the Oak Table
By: Pete Finnigan, Alex Gorbachev, Randolf Geist, Tim Gorman, Connie Green, Charles Hooper, ...
Paperback: 592 pages (January 20, 2010)
Apress

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company's investment in Oracle Database technologies. You'll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than lettin g it manage you.


Oracle Books Expert Oracle Practices: Oracle Database Administration from the Oak Table [Kindle Edition]
By: Pete Finnigan, Alex Gorbachev, Randolf Geist, Tim Gorman, Connie Green, Charles Hooper, ...
Electroni: 592 pages (January 20, 2010)
Apress

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company's investment in Oracle Database technologies. You'll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than lettin g it manage you.


Oracle Books Oracle SQL Recipes: A Problem-Solution Approach
By: Grant Allen, Bob Bryla, Darl Kuhn
Paperback: 300 pages (November 18, 2009)
Apress

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. W hen you're under pressure to get results fast, Oracle SQL Recipes is there at your side.


Oracle Books Beginning Oracle Database 11g Administration: From Novice to Professional (Beginning from Novice to Professional)
By: Iggy Fernandez
Paperback: 400 pages (December 15, 2008)
Apress

Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.


Oracle Books Expert Oracle Database 11g Administration
By: Sam R. Alapati
Paperback: 1276 Pages (November 10, 2008)
Apress

A comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Also offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.


Oracle Books Pro Oracle Application Express
By: John Scott, Scott Spendolini
Paperback: 500 pages (August 25, 2008)
Apress

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packa ges and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates! Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more.


Oracle Books Troubleshooting Oracle Performance
By: Christian Antognini
Paperback: 616 pages (July 23, 2008)
Apress

What do you do when your database application isn't running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It's finding a solution that's difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.


Oracle Books Oracle Database 11g: New Features for DBAs and Developers [Kindle Edition]
By: Sam R. Alapati
Electronic: 602 pages (November 15, 2007)
Apress

This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November.


Oracle Books Oracle Database 11g: New Features for DBAs and Developers
By: Sam R. Alapati
Paperback: 602 pages (November 15, 2007)
Apress

This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November.


Oracle Books Pro Oracle Spatial for Oracle Database 11g [Kindle Edition]
By: Ravikanth V. Kothuri
Electronic: 824 pages (October 29, 2007)
Apress

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in todays mobile and highly connected world.


Oracle Books Pro Oracle Spatial for Oracle Database 11g
By: Ravikanth V. Kothuri
Paperwork: 824 pages (October 29, 2007)
Apress

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in todays mobile and highly connected world.


Oracle Books Beginning PHP and Oracle: From Novice to Professional
By: W. Jason Gilmore, Bob Bryla
Paperwork: 160 pages (August 24, 2007)
Apress

Beginning PHP and Oracle: From Novice to Professional offers comprehensive information on using the PHP scripting language in conjunction with Oracles database platform. PHP is one of the most prominent open source technologies in the area of web development, while Oracle is one of the most widely deployed and used database products. You'll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. The book is packed with pract ical examples based on the many years of real-world experience of authors W Jason Gilmore and Bob Bryla. This book is an ideal read for web designers or programmers wanting to create applications with PHP in an Oracle environment.


Oracle Books RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach
By: Darl Kuhn, Sam R. Alapati, Arup Nanda
Paperwork: 160 pages (August 20, 2007)
Apress

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Scared? You should be. But theres help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracles backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. When the pressure's on, you dont have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.


Oracle Books Forecasting Oracle Performance
By: Craig Scallahamer
Paperback: 269 pages (April 19, 2007)
Apress

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place. If you're an IT practioner who appreciates application over mathematical proofs than you'll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.


Oracle Books Pro Oracle Collaboration Suite 10g
By: John Watson
Paperback: 400 pages (September 25, 2006)
Apress

OCS is becoming the dominant product for large-scale collaboration--blending core functions of e-mail, file serving, and diary management with the additional functionality of web conferencing, instant messaging, and wireless access. Pro Oracle Collaboration Suite 10g provides all you need to know to install and configure OCS for use, but this book is much more than a to-do list. It covers the architecture of the server processes and the applications, giving you the theoretical background to tak e OCS beyond the basics. There's no need to worry if you're new to the Oracle database, Oracle Components for Java environment (OC4J), HTTP web servers, or LDAP Internet directories--everything is explained carefully. But if you are already familiar with these topics, you'll learn how to fully exploit them in order to optimize your OCS installation.


Oracle Books Pro Oracle RAC on Linux: Installation, Administration, and Performance
By: Julian Dyke, Steve Shaw
Paperback: 700 pages (August 7, 2006)
Apress

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many ot her topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.


Oracle Books Oracle Applications DBA Field Guide
By: Elke Phelps, Paul Jackson
Paperback: 264 pages (March 31, 2006)
Apress

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux servers--all in an easy reading and quick-to-navigate fo rmat. Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Appli cations Release 12 and Fusion.


Oracle Books Pro Oracle 10g Performance Tuning
By: Soumendra Paik
Paperback: 450 pages (March 20, 2006)
Apress

If you are constantly under time pressure from SLAs or product release deadlines, then pick up a copy of Pro Oracle 10g Performance Tuning. This practical field guide will help you diagnose and resolve common, everyday problems such as poorly performing SQL queries, database and session hang, and sudden slow performance of a production database. Author Soumendra Paik includes comprehensive demos of the Oracle performance diagnostic toolkit. You will learn to identify and analyze a performance b ottleneck, isolate the root cause, apply different possible resolutions, and then quantify performance improvements&emdash;all in a quick and effective manner.


Oracle Books JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution Approach
By: Mahmoud Parsian
Hardcover: 504 pages (March 13, 2006)
Apress

JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the author's other book, JDBC Recipes: A Problem-Solution Approach, leaves off. This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer's application development.


Oracle Books Cost-Based Oracle Fundamentals
By: Jonathan Lewis
Paperback: 520 pages (November 5, 2005)
Apress

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong? If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL. The cost-based optimizer is simply a piece of code that contains a model of how Oracl e databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.


Oracle Books Expert Oracle Database 10g Administration
By: Sam R. Alapati
Paperback: 1304 pages (September 16, 2005)
Apress

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples--not just "showcase" examples. This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring O racle DBA needs to build and admisiter complex Oracle 10g databases.


Oracle Books Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
By: Thomas Kyte
Paperback: 768 pages (September 15, 2005)
Apress

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Each feature is taught in a proof-by-example manner, n ot only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focus es solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.


Oracle Books Expert Oracle JDBC Programming
By: R.M. Menon
Paperback: 708 pages (May 30, 2005)
Apress

With Oracle in the process of de-supporting SQLJ, JDBC is now really the only recommended means of interfacing between Java and Oracle. Consequently, this book is a must have for any developer building an Oracle Java application. Many Java developers tend to treat Oracle as a "black box"; as a consequence, developers tend to write incorrect, non-scalable code. If you don't intimately know how Oracle works and expects you to program, you might avoid Oracle extensions to the standard for fear of your code becoming database-dependent. If you give in to that fear, you'll miss out on the extensive out-of-the-box functionality that Oracle offers. This book teaches you how to build efficient, high-performance, and robust Oracle-based JDBC applications. You'll discover the full details of Oracle's implementation of the JDBC 3.0 standard (what it supports, what it doesn't and what extensions Oracle provides), and more. This book tackles issues head-on, detailing concisely and clearly the vita l details of Oracle's architecture and mode of operation that directly impact the manner in which JDBC applications should be written. Only when armed with this knowledge, a willingness to exploit the database to its full potential in your JDBC code, and the ability to use Oracle's SQL and PL/SQL features when appropriate, is it possible to write truly efficient, robust, scalable and high performance applications.


Oracle Books Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7
By: Thomas Kyte
Hardcover: 1328 pages (April 25, 2005)
Apress

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is emin ently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle d atabases.


Oracle Books Mastering Oracle SQL and SQL*Plus
By: Lex de Haan
Paperback: 488 pages (December 30, 2004)
Apress

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database. This book is an effective tool for you to w rite effective SQL for the Oracle database. The text is fully compliant with the latest version of the ANSI SQL standard, and fully update for the Oracle 10g database. This book is a translation of popular Netherlands college text (currently in its third edition). Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.


Oracle Books PeopleSoft for the Oracle DBA
By: David Kurtz
Paperback: 456 pages (November 22, 2004)
Apress

This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft sys tem.


Oracle Books Pro Oracle Spatial
By: Euro Beinat, Albert Godfrind, Ravikanth V. Kothuri
Hardcover: 712 pages (November 15, 2004)
Apress

Oracle Spatial is changing the way spatial information is used in organizations. This book addresses: (1) the special nature of spatial data and its role in professional and consumer applications, (2) the issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data; (3) the Oracle Spatial solution and the integration of spatial data into enterprise databases; and (4) how spatial information is used to understand business and support decisions, to manage cust omer relations, and to better serve private and corporate users. Pro Oracle Spatial shows how any Oracle application that has a spatial element (e.g. postcode) can take advantage of Spatial functionality. Thoroughly tech reviewed, this book contains case studies of more advanced applications of spatial in healthcare, telecom, retail, and distribution industries. Pro Oracle Spatial is based on extensive feedback from training courses, discussion lists, and customers. It recommends best practice approaches to the most common problems with which developers struggle.


Oracle Books Pro .NET Oracle Programming
By: Mark A. Williams
Paperback: 472 pages (November 2, 2004)
Apress

This book never loses sight of its instructional mission: to effectively utilize the Oracle database from the .NET environment. Though Visual Studio and Oracle form a popular and powerful duo, there is a noticeable lack of written material in this area. The result: projects that often turn out with less-than-optimal solutions, due to lack of "synergy" between the application developer and the database. The primary code in the book will be C#, but the code download will also be available in VB.N ET (with an appendix describing terms of use). Hence, this book provides a one-stop reference for any VS.NET programmer using Oracle. The author maintains solid focus on databases - emphasizing the use of specific features from a Visual Studio application. The text also includes crucial aspects of developing Oracle-based applications. Assumably, you are already comfortable with the VS.NET environment, and with the aid of this book, you will come to work effectively with the Oracle database as we ll.


Oracle Books Oracle Application Server 10g: J2EE Deployment and Administration
By: Erin Mulder
Paperback: 400 pages (September 6, 2004)
Apress

This book is based on the very latest version of Oracle's fully J2EE- certified Application Server (previously called Oracle9iAS). Oracle Corp.Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability. Deploying J2EE applications and configuring the application server are known to be the most tricky and non-standard elements of J2EE development, and thus they receive scant attention in general J2EE texts. This book provides a focused, no-frills guide to getting J2EE applications up and running on 10G. It covers Oracle's J2EE container, OC4J (available for free for development purposes), in full detail and then moves on to explain how to configure and use the various enterprise-level features that come with the commercial editions.


Oracle Books Oracle Insights: Tales of the Oak Table
By: Dave Ensor, Tim Gorman, Kyle Hailey, Anjo Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, James Morle, Mogens Norgaard, David Ruthven
Paperback: 456 pages (July 23, 2004)
Apress

Apress has gathered 12 of the most talented and famous Oracle experts in the world to bring you Oracle Insights, Tales of the Oak Table. Eleven of the talented 12-author team are members of the prestigious Oak Table society and, each author has contributed by writing a single chapter. With a combined 90 years of Oracle experience, this impressive team has worked on some of the very largest and most complex (and in some cases, most infamous) Oracle projects in the world. Oracle Insights, Tales of the Oak Table is the collected experiences of the Oak Table team, placed against the backdrop of Oracle's evolution, and highlights some of the groundbreaking software and techniques that the authors invented in response to the challenges facing them, and how these techniques are relevant today. Each chapter of Oracle Insights, Tales of the Oak Table, is based on the author's real life experiences working with Oracle on various significant projects. The chapters are written in an anecdotal, hu morous manner, with the underlying intent to teach readers the general lessons learned from these projects and, more specifically, the techniques that emerged or evolved as a result of these projects. As described in Oracle Insights, Tales of the Oak Table, some of the authors will have crossed paths during certain projects described in the book. The book will provide a foldout color map, which attempts to show the time, and project where the authors met which, helps the readers to understand t he incredible relationship, both professional and personal, that the Oak Table experts have.


Oracle Books Mastering Oracle PL/SQL: Practical Solutions
By: Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox
Paperback: 648 pages (January 1, 2004)
Apress

Stop dreaming small, or you will always be small. From the beginning of time, people have been working for a living and, chances are, you're carrying on this tradition. Whether you labor as a frontline worker or toil in high-level management, this book is for you. This isn't a Greek tragedy nor a retelling of the woes of the business world that we hear about every day in the news, and it's not a comedy that pokes fun at the idiocies that people witness daily in the workplace. Unite the Tribes: E nding Turf Wars for Career and Business Success shows the imaginary lines that divide companies into separate "tribes," with each fighting the other in small and petty turf wars. From this new perspective, you'll see how such internal divisiveness weakens your business and makes employees vulnerable to competitors in the marketplace.


Oracle Books The Art and Science of Oracle Performance Tuning
By: Christopher Lawson
Paperback: 459 pages (July 1, 2003)
Apress

Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success. The Art and Science of Oracle Performance Tuning shows you: A proven process for performance tuning How to objectively categorize the problem The human and business aspects of tuning as well as the technical know-how How to trace problems to their root cause Analyzing the cost of SQL statements Gathering statistics - achieving quantifiable results Devising and testing a solution Case studies throughout illustrate key points


Oracle Books Expert Oracle9i Database Administration
By: Sam R. Alapati
Paperback: 1248 pages (April 15, 2003)
Apress

This is the only real Oracle 9i Database Administration book on the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA of Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases. "Expert Oracle9i Database Administration" is thorough in covering all aspects of the 9i database and also includes a UNIX primer, as well as an introduction to SQL and PL/SQL. Sam R. Alapati covers the entire spectrum of the new Oracle 9i RDBMS softwa re and clearly explains how to use all of its powerful features. Currently, there is no one book that combines the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. Sam R. Alapati's book fills that gap well, by providing all the necessary material in one comprehensive volume. "Expert Oracle9i Database Administration" is designed as the most complete Oracle 9i database text available today. It takes several courses, as well as mastery of several Oracle manuals, to become a proficient DBA. A major focus of this book is on the most important features of the Oracle 9i database. Readers will be able to become expert Oracle DBAs by using this book.


Oracle Books Oracle9i PL/SQL: A Developer's Guide
By: Bulusu Lakshman
Paperback: 696 pages (November 12, 2002)
Apress

"Oracle9i PL/SQL: A Developer's Guide" is intended both for intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9i features. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. "Oracle9i PL/SQL: A Developer's Guide" is a solid source for the development of Oracle9i PLSQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial. Bulusu Lakshman is an experienced Oracle develope r with more than 10 years of software design and development experience using Oracle and its related tools, including PL/SQL and Java. He's the author of "Oracle Developer Forms Techniques" and "Oracle and Java Development", both of which have been well received. He also holds an Oracle Master credential from the Oracle Corporation, is an Oracle Certified Professional (OCP) application developer, and is a double honors graduate in computer science and engineering and mathematics. He has presente d at numerous international and national conferences on Oracle and its tools, and published articles in various technical magazines and journals. Lakshman is currently employed by Compunnel Software Group Inc., a leading technical consulting firm based in New Jersey.


2001-2011 Oracle-Books.com