Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource.

Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource.

Expands on Feuerstein's first book, Oracle PL/SQL Programming, taking you deep into the world of PL/SQL packages. Includes PL/Vision shareware library of packages. Demonstrates how to construct and properly build PL/SQL packages, providing a full-use shareware version of PL/Vision and a library of dozens of packages written by the author on the companion disk. Original. (Advanced).

Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query-including new features from Oracle versions 9i, 10g, and 11g-this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.

This latest edition of the #1 guide to advanced PowerBuilder techniques reveals powerful solutions to hard-core programming problems. From building business logic with User Objects, to creating layout forms with the HTML DataWindow, it offers step-by-step guidance on mastering the latest features of PowerBuilder 7. And, like its critically-acclaimed predecessor, it is loaded with proven, hard-to-find programming techniques, ready-to-run code, and real-world examples. The authors show how to: Dev elop applications using PowerBuilder's new and improved user interfaceProgram using PowerBuilder Foundation ClassesBuild advanced applications with integrated Internet tools Develop robust, scaleable distributed applications with Jaguar CTSDevelop Distributed PowerBuilder (DPB) applications Interface with Microsoft Messaging API, Open Repository CASE API, Word, Excel, Windows SDK, and version control softwareSolve network and performance problems Test and debug PowerBuilder applications. CD-ROM includes: Source code from the book HOW 3.0 Learning Edition demo

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

The book starts with the history of versions and the advantage of learning BI publisher is that BI publisher developer can develop reports not just for Oracle but also for Siebel, JD Edwards and PeopleSoft. The book gives step by step guided practice lessons. In short I would recommend this will be a great selection to start with.

Taken from our five day Basic PowerBuilder course, this book provides a hands-on introduction to all aspects of application development with PowerBuilder. Each component is covered in the context of using PowerBuilder to develop Windows-based, client/server production business applications. The topics are reinforced through a series of hands-on lab exercises in which the reader creates a fully functional PowerBuilder application. The lab setup and solution diskette included with the book provide s the files required to perform the hands-on labs, and includes a set of solutions to the lab exercises for student review. An instructor kit is provided, the kit includes the PowerPoint Slides and the instructor notes. This is the most popular PowerBuilder courseware on the market.

Beginning Database Programming with Oracle Application Express shows novice database developers and power users how to master Application Express to build effective web-based Oracle database applications. The author will provide hands-on, step-by-step guideance on the complete development process, through creating, customizing, and extending the application. The book gets quickly off the ground by showing how to build a simple application; it then gets into the details for extending the applic ation; reporting and charting; themes and templates, and security. The author also shows how to use packaged applications, as well as work with multiple applications. He concludes the book by providing guidance on data migration and integration with the Oracle environment.

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.

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 is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications. Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of p rogramming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations.

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.

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.

Are you fully harnessing the power of information to support management and marketing decisions? You will, with this one-stop guide to choosing the right tools and technologies for a state-of-the-art data management strategy built on a Customer Relationship Management (CRM) framework. Authors Alex Berson, Stephen Smith, and Kurt Thearling help you understand the principles of data warehousing and data mining systems, and carefully spell out techniques for applying them so that your business gets the biggest pay-off possible. Find out about Online Analytical Processing (OLAP) tools that quickly navigate within your collected data. Explore privacy and legal issues...evaluate current data mining application packages...and let real-world examples show you how data mining can impact -- and improve -- all of your key business processes. Start uncovering your best prospects and offering them the products they really want (not what you think they want)!

Oracle Corporation, committed to supporting XML in a wide range of products, has XML-enabled its entire Oracle Internet platform--the Oracle8i database, Oracle interMedia, Oracle Application Server, and a variety of other products. Building Oracle XML Applications, by Steve Muench, Oracle's lead "XML evangelist" and a key Oracle XML developer, gives Java and PL/SQL developers a rich and detailed look at the many tools Oracle has provided to support XML development, such as the Oracle XML Parser, the Oracle XML SQL Utility, and the XSQL Servlet. The company describes Oracle8i as "the first XML enabled database." This book shows how to combine the power of XML and XSLT with the speed, functionality, and reliability of the Oracle database to build flexible applications. The author delivers nearly 800 pages of entertaining text, helpful and time-saving hints, and extensive examples that developers can put to use immediately to build custom XML applications.

Explains how to use the common gateway interface (CGI) to create and deliver dynamic content on the web. The second edition has been rewritten to demonstrate current techniques available with the CGI.pm module and the latest versions of Perl. Programming on the Web today can involve any of several technologies, but the Common Gateway Interface (CGI) has held its ground as the most mature method--and one of the most powerful ones--of providing dynamic web content. CGI is a generic interface for c alling external programs to crunch numbers, query databases, generate customized graphics, or performing any other server-side task.

A quick guide to everything anyone would want to know about the soaringly popular Internet programming language, Python. Provides an introduction to new features introduced in Python 1.6, and topics covered include regular expressions, extending Python, and OOP. The CD-ROM includes the source code for all of the examples in the text.

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.

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle DBA's this guide focuses on proactive tuning and scripting, and shows how to collect historical data and use it to develop signatures for all memo ry areas. Using these metrics DBAs will be able to develop scripts that will anticipate and correct upcoming SGA performance problems. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

Create dynamic, effective reports from Oracle databases using Crystal Reports 9 and the extensive information in this practical resource. Learn to use one of the most powerful data analysis tools to draw information from Oracle databases, query and rank data, consolidate results, and develop integrated, interactive reports. Plus, leverage the power of the Oracle database in your reports. You'll find full details on everything from Oracle SQL and PL/SQL functions, procedures, and expressions to t he Oracle data dictionary and the new Crystal object repository. Get the insider advice you need to optimize performance, solve difficult reporting problems, and integrate non-Oracle data.

The stability and reliability of the Linux operating system makes it an ideal platform on which to operate databases. Increasingly, major software vendors are designing their applications to run on Linux. DBA's Guide to Databases on Linux walks you through the installation and configuration of several major databases on Linux and provides a working example of an e-commerce Web site. Major commercial databases such as Oracle, Informix, Sybase, DB2 and Progress are covered in depth as well as the widely used freeware databases, MySQL and PostgreSQL. DBA's Guide to Databases on Linux is the ultimate resource and comparative reference for any DBA managing databases on Linux. This book is intended primarily for database administrators and Linux users who want to improve their skills and understanding of various databases. We hope you will come away with a better understanding of database design and implementation in general. This book will give you a better understanding of the Linux operat ing system when it is used as a database server.

CD-ROM contains the actual models that are described in the book, providing examples of the most commonly asked data mining questions regarding marketing, sales, and customer support applications. Complete working code written in SAS, the most popular mining modeling language, is also provided. Readers can use the CD-ROM to directly implement the models for business use--resulting in better campaigns, improved customer service, and increased profits. A step-by-step guide showing how to create an d implement models of the most commonly asked mining questions from a variety of disciplines. Provides proven techniques and numerous case studies that detail available data sources for developing target models. A walk through entire process of a data mining project.

This text, Data Mining: Building Competitive Advantage, resulted from the revelation that data mining is becoming mainstream and that there are few books about data mining devoted to the business professional. It provides an innovative, easy approach to learning data mining for business professionals, students, and consultants. The CD-ROM at the back of the book makes learning data mining a hands-on activity. You can try out different software packages available for data mining and learn how the se tools are being used to solve industry problems. This book focuses on how knowledge discovery is used in different industries, and discusses several of the data-mining software products available. Sample studies are provided for specific industries, including retail, banking, insurance, and healthcare. This text takes a different approach to introducing data mining than the academic books currently on the market. The focus of this book is on industry applications, discussions of specific busi ness problems, and a hands-on teaching style to demonstrate how tools can be used to attain business benefit.

Here's the resource you need if you want to apply today's most powerful data mining techniques to meet real business challenges. Data Mining: Concepts and Techniques equips you with a sound understanding of data mining principles and teaches you proven methods for knowledge discovery in large corporate databases. Written expressly for database practitioners and professionals, this book begins with a conceptual introduction designed to get you up to speed. This is followed by a comprehensive and state-of-the-art coverage of data mining concepts and techniques. Each chapter functions as a stand-alone guide to a critical topic, presenting proven algorithms and sound implementations ready to be used directly or with strategic modification against live data. Wherever possible, the authors raise and answer questions of utility, feasibility, optimization, and scalability, keeping your eye on the issues that will affect your project's results and your overall success. Data Mining: Concepts and Techniques is the master reference that practitioners and researchers have long been seeking. It is also the obvious choice for academic and professional classrooms.

Data mining techniques are used to power intelligent software, both on and off the Internet. Data Mining: Practical Machine Learning Tools explains the magic behind information extraction in a book that succeeds at bringing the latest in computer science research to any IS manager or developer. In addition, this book provides an opportunity for the authors to showcase their powerful reusable Java class library for building custom data mining software.This text is remarkable with its comprehensiv e review of recent research on machine learning, all told in a very approachable style. (While there is plenty of math in some sections, the authors' explanations are always clear.) The book tours the nature of machine learning and how it can be used to find predictive patterns in data comprehensible to managers and developers alike. And they use sample data (for such topics as weather, contact lens prescriptions, and flowers) to illustrate key concepts. After setting out to explain the types of machine learning models (like decision trees and classification rules), the book surveys algorithms used to implement them, plus strategies for improving performance and the reliability of results. Later the book turns to the authors' downloadable Weka (rhymes with "Mecca") Java class library, which lets you experiment with data mining hands-on and gets you started with this technology in custom applications. Final sections look at the bright prospects for data mining and machine learning on th e Internet (for example, in Web search engines).

A guide to the use of ERwin--a visual data modeling tool that supports logical and physical data modeling. The program supports the design of large, complex enterprise models by dividing them into smaller more manageable subject areas which allows multiple views of the same subject area. After describing the basics of modeling concepts and the program, the author explains how to use ERwin to create a logical model that represents necessary information requirements and business rules. Finally the use of database administration for developing physical models is explained. From the first chapter, author Carla DeAngelis skillfully explains the normally complex concepts of Data Modeling-a critical success factor in the information-based enterprises of today. Carla tackles complex topics such as Logical Data Models, Modeling Methodologies, Relationships, and Attributes in a clear style that makes it simple for anyone to begin applying them immediately. Once the foundation has been laid, Carl a teaches you to develop your own databases with ERwin.

Data warehouses store millions of records, allowing managers to ask the big-picture questions about their businesses. The authors of Data Warehouse Design Solutions share their expertise in designing successful data warehouses and concentrate on understanding business processes within a variety of industries. First, the authors outline the promise--and potential hurdles--of data warehousing. They thoroughly explain the idea of dimensional data, which is used to represent the quantities or attrib utes that can be queried in a data warehouse. The authors argue that data warehouses need to adapt to changing business conditions and often must be more flexible than planned. They advise building the Enterprise Data Warehouse (EDW) as a series of interlocking data marts (which contain different dimensions). Developers can build part of a solution and add new data marts later. The result is a more adaptable approach to warehousing data. The heart of Data Warehouse Design Solutions is the descri ptions of data warehouses tailored to specific industries--sales, marketing, fulfillment, production, inventory, and capacity--using real-world businesses. The authors offer business models, sample dimensions, database schema, and sample reports for each business area. Later chapters discuss more advanced areas for data warehousing, including budget tracking, financial reporting (and managerial accounting), and even how to look at profitability and intellectual capital. The authors round out the ir nuts-and-bolts tour of today's businesses with a summary of the various measures that fit each type of organization. Finally, the authors come back to theory, with some ideas on building effective systems that are fast and that generate easy-to-read reports. The last chapter argues convincingly that their incremental approach to building data warehousing has some distinct advantages.

In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.

If you want to see how your next database project can profit from object-oriented design, check out Database Design for Smarties, a lively and intelligent guide to using objects in databases. The book begins with a tour of some underlying factors in modeling databases. Here, the author distinguishes between the external, conceptual, and internal models of database design.) Then it's on to data architectures, be they the traditional relational or the newer object-relational and object-oriented (O O) database types. After discussing some of the pitfalls of gathering and implementing user requirements, the author looks at UML notation for use case diagrams. (His example here, a crime database for tracking Sherlock Holmes's stories, along with criminals and clues, is both intelligent and entertaining.) The author's guide to UML class design is topnotch. He covers basic and advanced OO concepts such as inheritance, aggregation, composition, and polymorphism with clear and concise explanation s. He also shows you how to model business rules using objects and UML class diagrams. The most valuable part of this book comes with the mapping of UML class diagrams onto three different kinds of databases: relational (on Oracle7), object-relational (on Oracle8), and object-oriented (on the POET platform). The author shows how to emulate object-oriented ideas successfully using stored procedures and triggers, even if you are not running on a "true" object-oriented platform.

Examples abound in database applications of well-formulated queries running slowly, even if all levels of the database are properly tuned. It is essential to address each level separately by focusing first on underlying principles and root causes, and only then proposing both theoretical and practical solutions. "Database Performance Tuning and Optimization" provides comprehensive coverage of database performance tuning using Oracle 8i and select 9i examples as the RDBMS. The coverage contains b oth theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methods. The book combines theory with practical tools (in the form of Oracle and Unix shell scripts) to address the tuning and optimization issues of DBAs and developers, irrespective of whether they use Oracle. Readers not using Oracle can implement the essential principles via scripts of their own written for the RDBMS used by them.

Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object- oriented logic component, and an information store). The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available. But the book's key contribution is a set of patterns that let developers isolate critical tasks like obje ct creation, information storage and retrieval, and the committing or aborting of transactions. The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

This text on the Structured Query language and the Programming Language/Structured Query Language (PL/SQL) in Oracle version 8 or higher offers step-by-step instructions supplemented by hands-on examples, exercise questions, and lab activities. Two real-life running databases are used as models to explore database issues. Early chapters cover relational concepts and database design techniques, and later chapters concentrate of the primary nonprocedural relational database language SQL and the pr ocedural language PL/SQL. Final chapters introduce the architecture and administration of Oracle 8.

This book focuses on discussing the issues that a DBA would face in extending existing systems for eBusiness. The book also discusses how DBAs can prepare themselves for the challenge. An example business 'DOeBIZ Corporation' is used to help the reader understand the various issues involved and how an Oracle DBA can deal with them.

Thakkar, a software engineer for Quest, shows how to create a web- enabled database application using the Java features of Oracle8i, reviewing the issues in such a project and suggesting ideas for using the Internet capabilities of Oracle8i to resolve those issues. An online coffee shop is used as an example project throughout the book to demonstrate analysis, design, implementation, testing and deployment. In Building e-Commerce Database Applications Using Oracle8i and Java from scratch, Meghra j Thakkar takes novice web programmers through the process of creating a web-enabled database application. You will look at the requirements, analysis, design, implementation, testing and deployment of an "Online Coffee Shop" from scratch. You will also learn to create database objects (tables and indexes), populate the database, and use SQL, PL/SQL and Java to manipulate the data. e-Commerce Applications Using Oracle8i and Java From Scratch (From Scratch)

By removing the guesswork from Oracle HTML manipulation, this book shows working examples of complex HTML-DBA database access and techniques for creating easy HTML-DB applications. All HTML-DB concepts are described, and working examples of each HTML-DB feature are provided. Examples of HTML-DB data access and document formatting, information on how to update Oracle HTML-DB, and methods of customizing applications with Themes and CSS are also included.

Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management-including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining-are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Simplifying the work of creating dynamic web pages with Oracle content is the focus of this guide, which provides working examples of connecting to Oracle and delivering data into an HTML page. It thoroughly details information on complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment. In my experience in the security world, including 32 years at the Central Intelligence Agency, I've not found anyone with more experience in the theory and practice of protecting your data than David Knox.

This comprehensive guide focuses on developing Web and component-based applications with PowerBuilder 7. With an experts look at the mechanics of the software, this complete reference shows how to develop powerful, industrial-strength applications that can access data-aware components in distributed PowerBuilder, Jaguar Component Transaction Server, and Microsoft Transaction Server. In addition, you'll learn how to take advantage of the Enterprise Application Studio to build and deploy enterpris e Web, distributed, and client/server applications. The online web site is packed with sample applications, source code, reference material, as well as links to author's other articles. Some of the topics covered in this book are: Developing Component-centric Applications, Building Jaguar CTS Components/Clients, Building COM/MTS Components/Clients, Building and Using Java Components, Automation Servers, Remote Debugging, Using the JavaBeans Proxy, Introduction to Java, Java for PowerScript'ers, Web Development and Deployment Kit, DataWindow Web Control, OLE DB, JDBC, CORBA, Adaptive SQL Anywhere, Adaptive Server Enterprise, and lots more.

Written by the former principal product manager for Grid Computing at Oracle, this is the only book on the market that explains how to take full advantage of the agility, reliability, and low cost of Enterprise Grid Computing in the Oracle environment. The book discusses the technologies and processes involved in moving towards the grid model at every layer of the IT stack, including storage, servers, databases and applications.

The Essential Guide to PeopleSoft Development and Customization is an exhaustive, as well as practical, guide that covers PeopleSoft 7.5 and many new features in release 8.0. Both novice and experienced programmers will benefit from the detailed coverage of topics ranging from the basics of Application Designer to the proper use of PeopleCode within the Application Processor. The book serves as both a reference and a tutorial and covers advanced topics that other books avoid. The reader can gain valuable expertise by following the exercises and building sample applications and utilities. Extensive coverage of PeopleCode including scroll and function library examples can be found as well as methodology behind customization and upgrades. Discover how to effectively utilize SQR and Process Scheduler. Master various levels of PeopleSoft security. Most developers won't touch PeopleSoft COBOL programs with a ten foot pole. Expand your horizons by uncovering the secrets of PeopleSoft COBOL an d the PTPSQLRT module and even walk through a sample customization. Application Engine is a powerful PeopleTool - but one of the least understood. Through a series of simple but effective exercises the reader will learn Application Engine concepts such as dynamic SQL, decision logic and dynamic sections. A useful Application Engine utility is produced that will enhance the delivered Process Scheduler panels. This book takes a soup-to-nuts approach leading the reader through the full cycle of app lication development.

A soup-to-nuts guide to building and managing high-performance Oracle8i data warehouses In an effort to help companies manage what Information Week has referred to as the "Web Data Deluge," Oracle has released Oracle8i (the "i" stands for "Internet"), a major upgrade to their flagship database product that provides powerful new data warehousing capabilities. In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman provide database dev elopers and administrators with complete, detailed coverage of all they need to know to build and manage a fast, high-performance data warehouse using the Oracle8i technology. Step-by-step, they cover all the bases, including designing a data warehouse for optimum performance, building a data warehouse, loading data into the data warehouse, improving warehouse performance with aggregate data, and administering data warehouse performance.

McGraw-Hill is the exclusive publisher of Oracle Press, working closely for more than ten years with Oracle experts and the user community to develop the most authoritative, comprehensive, and current references for Oracle products and technologies. Written in an accessible, engaging, and logical way this book will quickly become the fingertip quick reference for Oracle database administrators who want to get more done faster. Filled with shortcuts, this handy reference is divided into logical s ections: Administration, Tuning, backup and recovery, SQL and Pl/SQL, troubleshooting, and a general section on interesting ways to get everything done that has to be done. From the exclusive Oracle Press, this will be a well-thumbed reference that will have to be on every DBA's bookshelf.

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 em inently 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 Orac le databases.

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.

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.

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.

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.

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.

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.

Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

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.

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.

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.

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.

I quickly glanced through it and knew at the first sight that these are truly useful resources for any beginner in Oracle Apps. The topics of KFF and DFF are very well explained enough to be an expert.

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.

Opportunities presented by mobile and wireless applications are numerous, and this book provides an objective analysis of both the potentials and pitfalls, pointing out situations where mobile technology may or may not be the right solution. For those businesses where it does fit, the authors guide readers on how to form a strategic vision and tactical plan for implementing real-time/anytime communications. Detailed case studies demonstrate how a particular company or agency has saved time, mone y, or labor by going mobile.

Flexible, reliable, and inexpensive, enterprise grid computing is the ideal solution to today's changing business needs. Perfect for business decision-makers, Grid Revolution provides an accessible overview of this technology. The book covers current grid standards activities and outlines the strategic steps required to phase grid computing into an existing infrastructure.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Linux and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

High Performance Oracle Data Warehousing takes readers beyond the basics, showing them how to create compact, efficient, lightning-fast data warehouse systems with Oracle. The CD-ROM contains all examples and source code used in the book, including SQL scripts, optimized database tables, templates, and more. High Performance Oracle Data Warehousing provides everything that the Oracle developer and DBA need to know to design and implement fast and functional Oracle data warehouses. Using proven t echniques from actual systems, this book is full of practical tips and tricks for getting the most out of the Oracle architecture and ensuring maximum performance from the data warehouse. You'll also find advance information on the eagerly awaited Oracle8. And unlike other books on data warehousing, High Performance Oracle Data Warehousing contains invaluable information and actual code examples that demonstrate the use of Oracle data warehouse features.

Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"–– that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system––not just the database. High-Performance Oracle is a h ands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.

More than half a million job seekers turn to this classic guide to write better resumes. It has been updated and revised to satisfy the needs of today's candidates. Readers now get more than 150 resumes covering an array of careers, with variants reflecting all career stages. All resume types and formats are covered, with a wealth of word-processing formatting solutions. In addition, there are expert tips on how to conduct a successful job search, compose dynamite cover letters, and ace any inte rview.

This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that hav e been used to attack databases (and that have since been fixed). These will often be explained to an internals level. There are many sections which outline the anatomy of an attack before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape both from a business and regulatory requirements perspective as well as from a technical implementation perspective.

Oracle database administration goes far beyond installation and tuning of the database - topics covered by the majority of books on the market. As DBAs become more involved in the business process, architecture, and planning, there may be more to do up front, but the end result is less chaotic. To better prepare those who are up to the new eBusiness challenges, the chapters in this book have been organized with information to not only provide IT professionals with information that can be applied for a more challenging and successful career, but also for those companies who are trying to attract and retain them.

Installing, Upgrading and Maintaining Oracle E-Business Suite Applications Release 11.5.10+" is OnCallDBA and Solution Beacon's latest collaboration. Topics include Release 11i Concepts and Architecture, Oracle10g, Installing Release 11i, Upgrading or Migrating to Release 11i, Maintaining Release 11i, Administering Release 11i, Securing Release 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Release 11i Reporting, and Tuning and Troubleshooting. Co-authored by Barbara Matth ews, John Stouffer, Randy Giefer, Karen Brownfield, Jeff Holt, James Morrow, Bruno Coon, Tim Sharpe and Faun deHenry, this book covers Oracle10g and E-Business Release 11.5.10+

Students need a big-picture introduction to Oracle and they need specific examples and steps. This concise book covers all of the topics students need in a first class by using step-by-step techniques with a rich set of databases to provide students with practical experience - all in one book.

Introduction to Oracle Discoverer 3i to 10g - New Horizons EditionBeginners course which main focus is to introduced End-Users with Little or No experiences with Oracle Discoverer reporting tools to achieve a functional level of knowledge in report creation, business objects usage and application interaction. This is a lab based book.

Provides a definitive description of the JDBC API, the technology that enables universal data access for the Java programming language. Combines a step-by-step tutorial with a comprehensive reference to all of the classes and interface, and gives in-depth explanations that go beyond the specification. Offers an introduction for those new to the Java programming language and to SQL, then walks through creating a JDBC application, with many examples, and discusses advanced topics. This book provid es the definitive description of the JDBC(tm) API, the technology that enables universal data access for the Java(tm) programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.

For every computer subject, there must be a large, shelf-straining tome that attempts to cover everything about the subject and more. JDBC Developer's Resource fills that niche for JDBC. Taylor's book opens with information about the Java language, including the now-hackneyed story of the language's development and a comparison to C and C++. Then, there's a valuable chapter for programmers who haven't done database work before that explains in clear terms how relational databases work. After a g lancing introduction to the JDBC application programming interface (API), the author walks the reader through the creation of all the critical elements of a JDBC application, including inserts, deletes, and updates. He covers the applet-specific implications of JDBC and explores three-tiered databases. The entire second half of JDBC Developer's Resource is given over to a full JDBC API reference.

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.

Ideal for any Java programmer trying to master JDBC database programming in a hurry, the remarkably concise and useful JDBC: Practical Guide for Java Programmers offers an example-based quick tour of essential APIs and techniques that you can use every day at your desk.

Welcome to the Java 2 Programmer's Interactive Workbook. This book will help guide you as you learn the Java programming language, which is regarded as the future of computer programming. Never before has a computer language so successfully combined a powerful object-oriented language with all of the graphical tools needed to create a fully functional program that can run on any system and in any Web browser. With the advance of the Internet, Java has become the language of choice for developers who need to create and distribute their applications quickly. Java was developed by Sun Microsystems in the early 1990s and has been gaining popularity every since. Prior to Java, the two main languages used by the computer industry were C, and C++. C is simple, powerful, and sometimes elegant, but it is also a procedural language. C++ is object-oriented, but also hugely complex and requires a great deal of overhead to maintain a program. Both languages are also machine-dependent, meaning that their programs only run on one type of computer (PC, Mac, Unix). The program must be recompiled, and sometimes rewritten, to work on a different computer. This can lead to long development times for projects. Likewise, neither C nor C++ have built-in graphical utilities. Both must use special libraries that allow the program to use the windowing features of the computer. These libraries can be vastly different on various computer platforms, requiring more rewriting of the programs.

Computer professionals increasingly rely on the Web, online help, and other online information sources to ease information pain. Now The Java Enterprise CD Bookshelf gives you convenient online access to your favorite books from your CD-ROM drive. The Java Enterprise CD Bookshelf contains a powerhouse of books from O'Reilly: both electronic and print versions of Java Enterprise in a Nutshell, plus electronic versions of Java in a Nutshell, 3rd Edition; Java Foundation Classes in a Nutshell; Ente rprise JavaBeans, 2nd Edition; Java Servlet Programming; Java Security; and Java Distributed Computing. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The Java Enterprise CD Bookshelf can be read using any Web browser. The books are fully searchable and cross-referenced. In addition to individual indexes for each book, a master index for the entire library is provided.

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed i nformation and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and perfo rmance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

If you're a Java programmer working in an Oracle environment, you're probably familiar with JDBC as a means of accessing data within an Oracle database. SQLJ takes you further, allowing you to access a database using embedded SQL statements. Java Programming with Oracle SQLJ shows you how to get the most out of SQLJ. Layered on top of JDBC, SQLJ greatly simplifies database programming. Rather than make several calls to the JDBC API just to execute a simple SQL statement, SQLJ executes that state ment simply by embedding it within the Java code. In this book, Jason Price explains SQLJ programming from a task-oriented point of view. You'll learn how to: Embed queries and other SQL statements within Java programs. Deploy SQLJ code not only on client machines, but also to JServer--Oracle's Java engine built into the database. Use advanced techniques for working with collections, streams, large objects, and database objects, all without leaving the comfort of the SQLJ environment. Tune SQLJ programs for maximum performance. Throughout this book, the exposition of SQLJ and SQLJ programming techniques reflect the author's many years of professional experience as a programmer and consultant. Examples are first-rate, enabling you to learn SQLJ in no time. If you're writing Java code to access an Oracle database, you can't afford not to know about SQLJ.

A beginner's guide to programming terminology, fundamental concepts, and techniques for writing code. The author focuses on the four basic constructs of programming--sequences, loops, branches, and modules--then walks step-by-step through the development of a word counter and a guessing game. The CD-ROM contains Python version 1.5.2 and a Python tutorial. Topics covered include data types and variables, debugging, and namespaces. Also includes sample applications that illustrate ideas and techn iques in action. The CD-ROM contains an online Python tutorial.

Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Among our best-selling books on PL/SQL, Learning Oracle PL/SQL is the first one a newcomer to the language will want to read . Beginning with a discussion of what PL/SQL is and what it's good for, this book then presents language features, one at a time, in an engaging and readable way. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters. Topics include: Why use PL/SQL at all? Fundamental components of the language Fast ways to read and write Oracle data Organizing code for reusability Using PL/SQL to generate web-based applications Making sure your PL/SQL application is secure against hackers Benefits of using third-party developer tools Interacting with the internet (e.g., sending email from the database) New PL/SQL features in Oracle9i Learning Oracle PL/SQL introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.

The authors of Learning Python show you enough essentials of the Python scripting language to enable you to begin solving problems right away, then reveal more powerful aspects of the language one at a time. This approach is sure to appeal to programmers and system administrators who have urgent problems and a preference for learning by semi-guided experimentation. First off, Learning Python shows the relationships among Python scripts and their interpreter (in a mostly platform-neutral way). T hen, the authors address the mechanics of the language itself, providing illustrations of how Python conceives of numbers, strings, and other objects as well as the operators you use to work with them. Dictionaries, lists, tuples, and other data structures specific to Python receive plenty of attention including complete examples.

Starts with very simple Oracle SQL concepts and slowly builds into more complex query development and PL/SQL. Covers SQL as it is invoked via SQL Plus, a command-line system to launch interactive queries. Provides an appendix for UNIX users of Oracle.

In their critically acclaimed book, Data Mining Techniques, Michael Berry and Gordon Linoff showed readers how to use data mining techniques to improve marketing and sales. In their new, book they take readers to the next level with a series of step-by-step lessons, built around 20 real-world cases illustrating how they used their techniques to solve problems.

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.

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner.

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.

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative tec hniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory. Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It c overs Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType. Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There's some discussion of hooks for software developers, as well. The authors' approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for view ing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i.

A guide to Oracle DBA management scripts, this book is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. An online code depot full of more than 200 pretested Oracle DBA scripts is provided. Coverage of all areas of Oracle database administration including data files, tablespace, and table and index management scripts is included. Also reviewed are mechanisms for automating Oracle database administration tasks and tips for automat ing without buying expensive tools.

If you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.

Prepare for the Oracle Certified Administrator Oracle Application Server 10g exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the exam 1Z0-311, including installation, configuration, and management of Oracle Application Server 10g, as well as details on Oracle Internet Directory, Oracle HTTP Server, Oracle Single Sign-On Server, Oracle Portal, Oracle Application Server Containers for J2EE (OC4J), and Oracle Web Cache. In each chapter, you'll find cert ification objectives, examples, a two-minute drill, and a self-test to highlight what you've learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCA exam.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference.

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives. Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: In-depth coverage of official exam objectives Practical information on using SQL in a real-world Oracle9i en Hundr eds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Writing basic SQL SELECT statements Restricting and sorting data Displaying data from multiple tables Aggregating data using group functions Producing readable output with iSQL*Plus Creating and managing tables Controlling user access.

Here's the book you need to prepare for Exam 1Z1-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managi ng Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Featured on the CD The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Fundamentals I exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is a complete electronic version of the book.

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam. Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal. The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, desig n review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Prepare for the Oracle Certified Professional Oracle Database 10 g New Features for Administrators exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the upgrade exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. In each chapter, you'll find examples, practice questions, lab questions, a two-minute drill, and a chapter summary to highlight what you've learned. This book and CD-R OM package is the most comprehensive preparation tool available for this OCP exam.

This Oracle Press certification exam guide offers detailed coverage of all of the official exam objectives on the Oracle Certified Professional Administration II exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. Real-world examples, practice questions, and chapter summaries help certification candidates learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i D atabase: Fundamentals I exam.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals II exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals II exam.

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam--a required exam for upgrading your Oracle8i or earlier DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive pr eparation tool available for the Oracle9i Database: New Features for Administrators exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Get Certified with Official Exam Prep Material from Oracle Press. Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years

Here's the comprehensive and affordable self-study solution you need to prepare for the Oracle Database 10g Administration I and Administration II exams. These Study Guides were developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the reputation as the preferred publisher for IT certification exam candidates worldwide, each book provides: * Clear and concise information on database administration with Oracle 10g * Practical examples and insights drawn from the authors' real-world experiences * Leading-edge exam preparation software, including a test engine and electronic flashcards

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex's OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up-to-date for Oracle8i and include all the new features of Sybex's best-selling Study Guides. The companion CDs contain exclusive self-testing software. The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle's partners: Sun, Novell, Compaq, and HP. Sybex's Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self-testing software.

Boxed set certification kit for the Oracle 8i DBA exams, numbers 1Z0-001, 1Z0-023, 1Z0-024, 1Z0-025, and 1Z0-026. Includes three study guide texts, each with its own CD-ROM. Each includes custom testing engines with hundreds of sample questions, electronic flashcards for PC and Palm devices, and other helpful features.

Test your knowledge with exclusive software to prepare you for all five OCP Oracle8i DBA exams. --Contains 1000 questions in a tough adaptive format with a unique benchmarking feature to help you identify weak areas. --Delivers four sample exams for each test and is a great companion to the Sybex OCP: Oracle8i Study Guides.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book. The book you need to prepare for Exam 1Z1-032 Oracle 9i Database: Fundamentals II. Provides indepth coverage of official exam objectives and hundreds of challenging review questions. CD-ROM included.

The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

The popularity of object-oriented concepts, design, and programming has stimulated the need for a database system that enables a straightforward process to store and retrieve object instances. Exploring object-oriented features and techniques in Oracle DBMS, this book describes the fundamental aspects of data modeling and implementation in Oracle. The implementation of structural aspects of an object model are covered, including object types, collection types, object referencing, nested tables, and inheritance structures, as well as the behavioral aspects that include encapsulated member procedures and functions. The complete cycle of database design using object-oriented concepts, implementation on object-relational Oracle, and data manipulations using member procedures/functions and object-relational queries is also addressed.

Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. As this book reveals, these two worlds are not as far apart as they may seem. Today, there are many excellent and freely available software tools that Oracle developers and database administrators can use, at no cost, to improve their own coding productivity and their system's performance. Moreover, many of the finest Oracle developers are now making thei r source code freely available so their peers can build upon this code base. Oracle Corporation is even porting its RDBMS to Linux and starting to incorporate a growing number of open source tools in the company's own software. Oracle & Open Source describes close to 100 open source tools you can use for Oracle development and database administration, from large and widely known open source systems (like Linux, Perl, Apache, TCL/Tk and Python) to more Oracle-specific tools (like Orasoft, Ora c, OracleTool, and OraSnap). You'll learn how to obtain the software and how to adapt it to best advantage. The book abounds with code examples, download and installation instructions, and helpful usage hints. Not only does it tell you how to find and use existing open source code; Oracle & Open Source gives you the details and the motivation to build your own open source contributions and release them to the Oracle community. You'll lear n all about tools like the Oracle Call Interface (OCI) and Perl-DBI (Database Interface), which provide the glue allowing new open source tools to link into commercial Oracle software. With Oracle & Open Source as a guide, you'll discover an enormous number of highly effective open source tools, while getting involved with the thriving community of open source development.

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application. It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and generate reports that can be deployed over the web and gain better insight into your business. This how-to guide provides step by step instruct ions including screen captures to make it easier to design, build and optimize performance of the data warehouse or data mart. It is a must have reference for database developers, administrators and IT professionals who want to get to work now with all of the newest features of Oracle Database 10g.

The Topics Covered In This Book Are: Visualizing the Complete Oracle Environment, SQL: Structured Query Language, Oracle Database Concepts, Oracle Instance Concepts, Oracle in Action, Complete Oracle System Design: Steps of Implementation, Oracle Database Design, Oracle Network Administration, Oracle Database Management, Oracle Backup & Recovery Techniques, Oracle Performance Tuning. Everything in this book is covered in a step by step manner by first building reader s concept using analogi es, real world examples and then taking him/her to the steps of design implementation. The book covers Oracle 10g Database Administration for both Unix as well as Windows OS. The concepts and most of the stuff discussed in this book are equally good for other Oracle versions including 11g.

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.

Oracle 10g Developing Media Rich Applications is focused squarely on database administrators and programmers as the foundation of multimedia database applications. With the release of Oracle8 Database in 1997, Oracle became the first commercial database with integrated multimedia technology for application developers. Since that time, Oracle has enhanced and extended these features to include native support for image, audio, video and streaming media storage; indexing, retrieval and processing i n the Oracle Database, Application Server; and development tools. Databases are not only words and numbers for accountants, but they also should utilize a full range of media to satisfy customer needs, from race car engineers, to manufacturing processes to security. The full range of audio, video and integration of media into databases is mission critical to these applications. This book details the most recent features in Oracles multimedia technology including those of the Oracle10gR2 Databas e and the Oracle9i Application Server. The technology covered includes: object relational media storage and services within the database, middle tier application development interfaces, wireless delivery mechanisms, and Java-based tools.

Oracle 10g Developing Media Rich Applications is focused squarely on database administrators and programmers as the foundation of multimedia database applications. With the release of Oracle8 Database in 1997, Oracle became the first commercial database with integrated multimedia technology for application developers. Since that time, Oracle has enhanced and extended these features to include native support for image, audio, video and streaming media storage; indexing, retrieval and processing i n the Oracle Database, Application Server; and development tools. Databases are not only words and numbers for accountants, but they also should utilize a full range of media to satisfy customer needs, from race car engineers, to manufacturing processes to security. The full range of audio, video and integration of media into databases is mission critical to these applications. This book details the most recent features in Oracles multimedia technology including those of the Oracle10gR2 Databas e and the Oracle9i Application Server. The technology covered includes: object relational media storage and services within the database, middle tier application development interfaces, wireless delivery mechanisms, and Java-based tools.

This book is written with the objective of providing the students or professionals with the knowledge of how to develop and manipulate a relational database through the medium of the Internet. It provides a hands-on approach toward applying the database application concepts for Web development. In an academic environment, the book can be adopted in any class or course that emphasizes relational database application concepts and/or Web application development. This textbook goes beyond mere refin ements of database or Web application concepts. It contains many distinct features and presents concepts in a significant new way. These features together provide a complete package for Web application development.

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.

Oracle 10G Programming is a concise, streamlined guide to Oracle programming. It is ideal for students studying databases, and introduces the Oracle technology students need to know for a first database course. The Relational Data Model, Oracle SQL, PL/SQL, Web Programming with PL/SQL, Oracle JDBC, SQLJ: Embedded SQL in Java, Oracle Web Programming with Java Servlets, Oracle XML, Projects.

Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the dist ribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC. Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes net work configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

An oracle on Oracle, Byron Pearce takes the complexity out of the Oracle 11g database and helps readers work effectively in the Oracle 11g environment Begins with a friendly introduction to the basics of the Oracle database and then progresses to implementing Oracle in real-world situations, creating and protecting an Oracle database, and troubleshooting Covers the new features of Oracle 11g, including automatic memory tuning, fully automatic SQL tuning, automatic storage load balancing, and aut omatic diagnostic repository Devotes entire chapters to the oft-forgotten but critical topic of common mistakes that occur when installing Oracle, designing a database, and writing SQL code.

Covering all areas of Oracle Grid computing, this guide is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle 11g Grid with server blades. This comprehensive manual presents a complete method for the installation, configuration and design of Oracle Grid and 11g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. Also demonstrated is the use of Oracle Grid using t he Enterprise Manager Grid control utility.

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs an d Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.

From smaller businesses through to huge enterprises - users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems. This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment. The boo k does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams.

Oracle 11i E-Business Suite from the Front Lines is the first book to compile the tips, techniques, and practical advice for administering Oracle E-Business Suite 11i. The author examines Active Directory Utilities, patching, cloning, and the new features that 11i brings to the market. The book benefits those with limited experience with Oracle Application but with more extensive background in Oracle Database Administration. This volume is valuable to systems administrators or DBAs who have expe rience with older versions of Oracle Financials and want to expand their knowledge to include the changes inherent in 11i.

Time-tested information--Strategies come straight from an Oracle DBA who's worked in the trenches for the Quatar Government keeping systems online 24x7. 8i Coverage--Version 8i's web functionality makes working in 24x7 mode available to a wider spectrum of corporations. Specific discussions--Covers areas of database installation, configuration, and management of security, performance, and recoverability. Diagnostic and database monitoring scripts--Scripts can be deployed immediately to help DBAs achieve high-availability databases.

Oracle database administrators always have plenty on their plate. Oracle8i Administration and Management comes to the rescue with lots of guidance in creating and maintaining Oracle databases and keeping them running at top performance. This is the latest revision of the DBA guide that has previously covered Oracle7 and, more recently, Oracle8. This update adds full coverage of Oracle 8i and includes an integrated discussion of the new version's object-oriented additions to the popular SQL data base product. Author Michael R. Ault meticulously goes through the topics administrators care about most, presenting a detailed discussion of the underlying architectural details. By organizing chapters according to administrative functions, such as "Tuning Oracle Applications" and "Database Internals Tuning," Ault has created a text that is quite handy for on-the-spot reference. A number of useful appendices on the companion CD-ROM offer plenty of useful management tidbits, as well as all of t he code scripts used in the book and demonstration versions of management utilities.

Two members of the Oracle8i summary management development team explain how to design, implement, and administer data warehouses and data marts using the new Oracle8i database program. Dimension and fact tables, indexes, partitions, materialized views, and the Oracle discoverer, express, time series and enterprise manager are all discussed.

This book/CD-ROM shows how to use programming tools to bring databases to the Internet using the new integration between Java and Oracle. Coverage includes Oracle object-relational databases and the SQL language, Oracle PL/SQL and Java stored procedures, middleware, and Java components in the database. Material is written from a software developer's perspective, but will be of interest to application designers and system architects as well. Assumes background in Java and SQL. The CD-ROM contains sample code from the book for Linux/UNIX, Windows, and MacOS. Bonazzi develops performance monitoring tools for Java. Stokol is a Java trainer in the private sector. Oracle 8i and Java: From Client Server to E-Commerce

If you have Oracle9i, you have the database to beat all databases. Besides being among the cream of the crop when it comes to relational database packages, Oracle9i is one of the more complex. Oracle9i does some amazingly fancy things, but the easy things are sometimes tricky. Oracle9i For Dummies covers the tough stuff in a straightforward and conversational manner, touching on key points and new features. This friendly guide leads you through a complete tour of Oracle9i, hitting the highlight s the object relational world and these important product components: Enterprise Manager Console, Major DBA tools, SQL *Plus, XML Developer's Kit, Dataspeak & Java applets.

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Maximize all of the enhanced capabilities of Oracle9i using the precise information presented in this convenient resource, officially authorized by Oracle Corporation. Inside, you'll find full details on all the new Oracle9i features, including database administration and management improvements, architecture changes, performance enhancements, security advancements, and high-availability innovations.

PL/SQL Server Pages is a technology introduced by Oracle for developing Web applications by using Oracle's PL/SQL language as a server-side scripting language. This book is written with the objective of allowing the student to learn development of database-driven Web applications through the utilization of SQL and PL/SQL languages for relational database processing. It provides a hands-on approach toward Web development. To facilitate development of PL/SQL Server Pages, NetObject Fusion Web auth oring software is adopted to supplement the HTML coding of a Web page. There are sample databases, numerous examples and tutorials in the book to explain the various concepts. Each chapter ends with Review Questions and Problem Solving Exercises. The book is written for college students and moves at a pace suitable for students.

Like the earlier versions, this manual is intended for beginners and is not a reference book. This manual covers basics and advanced topics of SQL covering Oracle 8i version. This book is a training manual where anyone can learn SQL. This book has lot of exercises and solutions at the end of each chapter.

Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.

A quick glance at this book reveals an elaborate mix of information-presentation techniques. Procedures, complete with numbered steps, intermingle with bulleted lists that document options, and tables that explain alternative parameters that may be used in code to achieve different effects. The result is a guide that's handy for getting your initial familiarity with Portal (you can just follow the steps without deviation) as well as for reference when you're more expert (you can use the index to locate the tables and facts you need to see in order to solve problems). Read this one if you need to build Portal applications and don't have time for training.

Oracle Application Express 4.0 is a rapid web application development tool that works with the Oracle database. Using features like Plug-ins and Dynamic Actions, APEX helps you build applications with the latest techniques in AJAX and JavaScript. The Oracle Application Express 4.0 Cookbook shows you recipes to develop and deploy reliable, modern web applications using only a web browser and limited programming experience. With recipes covering many different topics, it will show you how to use the many features of APEX 4.0. You will learn how to create simple form and report pages and how to enhance the look of your applications by using stylesheets. You will see how you can integrate things such as Tag Clouds, Google Maps, web services, and much more in your applications. Using Plug-ins, Dynamic Actions, BI Publisher, translations and Websheets, you will be able to enhance your applications to a new level in APEX. This book will show you how to be Agile in the development of your web applications by using Team Development, debugging, and third-party tools. After reading this book, you will be able to create feature-rich web applications in Application Express 4.0 with ease and confidence. A practical reference guide with over 70 recipes for every APEX developer.

This latest edition of Scott Urman's definitive guide to PL/SQL programming under Oracle databases, Oracle8i Advanced PL/SQL Programming, takes into account the new features of the language under Oracle 8i. Urman cut out some of the introductory PL/SQL material that appears in his earlier Oracle works, letting him focus more fully on higher-level aspects of the language and advanced techniques for putting them to use. Still, quite a bit of introductory material - including information on PL/SQL development environments - appears here, so don't be afraid to dive into Oracle 8i PL/SQL with this book if you can afford to buy only one guide.

Modern web-based applications are moving rapidly away from simple HTML pages, with users expecting desktop styled rich internet applications. Oracle Application Express includes multiple built-in interfaces especially designed for adding JavaScript libraries and components. Ext JS is a polished, high performance set of customizable UI widgets with a well designed and extensible Component model. Combining Ext JS components with the well engineered server side processing provided by Oracle APEX is a recipe for success. Written by Oracle ACE, Mark Lancaster, this book is a complete practical guide to building robust desktop-styled web applications using Oracle Application Express and the powerful Ext JS JavaScript library. This book starts off by setting up a productive environment for Oracle APEX and Ext JS, preparing you to get ready to code, and then gradually introducing you to the Ext JS API. You then create a theme based on Ext JS into APEX from scratch, starting with integrating the Ext JS library into the page template, then covering all the template types.

From the exclusive publisher of Oracle Press books, here is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. You'll find coverage of installation, configuration, and tuning, using Java with Oracle Application Server 10g, and much more.

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server. This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms a nd Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web c aching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server. More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.

Develop flexible, cross-platform Web applications using Oracle Application Server 10g and this exclusive Oracle Press guide. Take advantage of the full support for all major Web development languages, APIs, and frameworks and learn to create and test applications quickly, interface with the Oracle database seamlessly, and deploy your applications to the Web securely. Inside you'll find full details on J2EE integration, Oracle Forms 10g , Oracle Reports 10g , OracleAS Discoverer 10g , OracleAS Po rtal, and Oracle JDeveloper 10g

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.

The Ultimate Job Reference & Career Guide for Oracle Professionals! Over 150 Certification Questions, Answers, and Explanations Our books are for readers who must absolutely land their next job in Oracle, and who want to improve their existing positions. ORACOOKOOK readers have a need for information they can use right now. Our series of Oracle interview questions books is a direct answer to that need for instant information in the modern workplace. Our books are written by Oracle practition ers and expert authors who have varied vast experiences in the world of information technology. If great careers begin with a good book, the best careers begin with ORACOOKBOOK Over 150 Certification Questions, Answers and Explanations guide you through your learning process. Suitable for developers of any and every level of Oracle expertise, the book is organized around design, performance tuning, and audit and security. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile implementations.

The Ultimate Oracle Application Server Portal Resource. Build dynamic, feature-rich enterprise portals using Oracle Application Server Portal and the expert information in this exclusive Oracle Press guide. You'll learn how to maximize the capabilities of Oracle Application Server Portal, customize your portals, integrate Oracle Forms and Oracle Reports, and add Java functionality. Oracle Application Server Portal Handbook covers all of the design, management, and security features available in Oracle Application Server Portal 10.1.4 alongside real-world solutions. Take full advantage of the built-in tools and wizards. Create rich end-user experiences quickly and easily. Customize pages and maintain site-wide consistency using HTML templates. Incorporate data from disparate formats using Oracle Application Server Portal's content management features. Build pages using OmniPortlet and the Web clipping studio. Write portlets with Java and Oracle JDeveloper. Implement SOA-based applicatio ns to connect business processes. Administer, tune, and secure Oracle Application Server Portal. Integrate Oracle Forms, Oracle Reports, and Oracle Discoverer workbooks

The Ultimate Oracle Application Server Portal Resource. Build dynamic, feature-rich enterprise portals using Oracle Application Server Portal and the expert information in this exclusive Oracle Press guide. You'll learn how to maximize the capabilities of Oracle Application Server Portal, customize your portals, integrate Oracle Forms and Oracle Reports, and add Java functionality. Oracle Application Server Portal Handbook covers all of the design, management, and security features available in Oracle Application Server Portal 10.1.4 alongside real-world solutions. Take full advantage of the built-in tools and wizards. Create rich end-user experiences quickly and easily. Customize pages and maintain site-wide consistency using HTML templates. Incorporate data from disparate formats using Oracle Application Server Portal's content management features. Build pages using OmniPortlet and the Web clipping studio. Write portlets with Java and Oracle JDeveloper. Implement SOA-based applicatio ns to connect business processes. Administer, tune, and secure Oracle Application Server Portal. Integrate Oracle Forms, Oracle Reports, and Oracle Discoverer workbooks

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.

Brand new, real-world case studies illustrating what needs tuning and why, and how to most effectively do it. Instructional troubleshooting flowcharts at the end of each chapter that relate back to the information in the chapter. Maximize the Performance of Your Oracle Applications System Troubleshoot and tune Oracle Applications Smart Client and Internet computing environments. Officially authorized by Oracle Corporation, Oracle Applications Performance Tuning Handbook provides a systematic app roach to resolving complex system-wide performance issues. Learn how to preempt serious problems as well as increase system capacity, improve scalability, and extend the life of existing system components.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Oracle Backup and Recovery 101 explains, step-by-step, how to manage database backup and recovery via physical file operations and logical data operations. The book also teaches you how to perform server-managed backup and recovery using Oracle Recovery Manager (RMAN). Officially authorized by Oracle Corporation, this hands-on guide shows you everything you need to know to implement a basic backup and recovery plan for your Oracle database and includes full details on setting up a small sample d atabase so you can practice the tasks covered throughout the book.

Describing the successful techniques employed by large Oracle database shops to ensure quality and uniformity, this guide contains real-world examples and a code depot. All areas of Oracle best practices management, including the Oracle Optimal Flexible Architecture and testing and quality assurance best practices, are covered in detail.

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. Now, with the introduction of Oracle8, PL/SQL has taken the next ste p towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packag es is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for Web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways.

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next ste p towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein'sOracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality.Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database.DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs.The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not d escribed in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book.Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively.

Written by Oracle experts, this book explains how to build custom BI applications using Oracle Business Intelligence Suite Standard Edition and Enterprise Edition. The book covers all of Oracle's BI product offerings, including Oracle Warehouse Builder and the recently acquired and incorporated Siebel Analytics product. Oracle Business Intelligence Suite Developer's Guide teaches you how to design a BI database, load data using Oracle's ETL tool, and execute reporting, publishing, and analysis. The book puts the tools in context and offers real-world advice on the most appropriate approach to take for specific BI deployments.

Drive better decision-making across your enterprise using the reporting and analysis techniques in this Oracle Press guide. Through clear explanations and detailed case studies, Oracle CRM on Demand Combined Analyses shows you how to deliver real-time insightful business intelligence to end users. Learn how to perform multiple queries, join tables, format result columns, and add interactivity to your reports. Methods for filtering the results of a combined analysis are also covered in this pract ical resource.

Drive better decision-making across your enterprise using the reporting and analysis techniques in this Oracle Press guide. Through clear explanations and detailed case studies, Oracle CRM on Demand Combined Analyses shows you how to deliver real-time insightful business intelligence to end users. Learn how to perform multiple queries, join tables, format result columns, and add interactivity to your reports. Methods for filtering the results of a combined analysis are also covered in this pract ical resource.

Create custom, interactive dashboards to deliver actionable business intelligence directly to end users with help from this Oracle Press guide. Oracle CRM On Demand Dashboards provides comprehensive coverage of the versatile features available in Oracle Answers On Demand coupled with detailed planning and design strategies for building and deploying reports and dashboards with Oracle CRM On Demand. Real-world examples and time-saving formatting tips are included throughout this practical resourc e.

Create custom, interactive dashboards to deliver actionable business intelligence directly to end users with help from this Oracle Press guide. Oracle CRM On Demand Dashboards provides comprehensive coverage of the versatile features available in Oracle Answers On Demand coupled with detailed planning and design strategies for building and deploying reports and dashboards with Oracle CRM On Demand. Real-world examples and time-saving formatting tips are included throughout this practical resourc e.

Foster long-term customer relationships and accelerate productivity using the proven strategies and best practices in this Oracle Press guide. Oracle CRM On Demand Deployment Guide shows how to set up, customize, and manage a dynamic software-as-a-service solution across your enterprise. Develop implementation plans, maximize user adoption, build applets and portals, integrate Web 2.0 features, and use analytics dashboards. The latest design, tuning, and data security techniques are also covered in this practical resource.

Foster long-term customer relationships and accelerate productivity using the proven strategies and best practices in this Oracle Press guide. Oracle CRM On Demand Deployment Guide shows how to set up, customize, and manage a dynamic software-as-a-service solution across your enterprise. Develop implementation plans, maximize user adoption, build applets and portals, integrate Web 2.0 features, and use analytics dashboards. The latest design, tuning, and data security techniques are also covered in this practical resource.

Link and Embed Oracle CRM On Demand Reports Integrate business intelligence directly into day-to-day business processes by presenting analytic reports to end users in applications. Oracle CRM On Demand Embedded Analytics shows you how to link and embed reports throughout Oracle CRM On Demand. This Oracle Press guide explains how to plan, design, and develop reports; make them available through hyperlinks; and embed reports in a variety of locations easily accessible to end users. Real-world exa mples and time-saving tips are included throughout this practical resource. Navigate the report development environment within Oracle CRM On Demand Configure administrative settings to access report development and embedding tools Design reports for linking and embedding in applications Format columns, filter data, and add and edit views, including pivot tables and pivot charts Add link functionality to Oracle CRM On Demand and your reports Embed reports using HTML and URL encoding Display rep orts inside dashboards and on home page screens Embed reports inside other reports Add reports and dashboards to custom Web tabs and desktop applications Include external sites in reports.

Link and Embed Oracle CRM On Demand Reports Integrate business intelligence directly into day-to-day business processes by presenting analytic reports to end users in applications. Oracle CRM On Demand Embedded Analytics shows you how to link and embed reports throughout Oracle CRM On Demand. This Oracle Press guide explains how to plan, design, and develop reports; make them available through hyperlinks; and embed reports in a variety of locations easily accessible to end users. Real-world exa mples and time-saving tips are included throughout this practical resource. Navigate the report development environment within Oracle CRM On Demand Configure administrative settings to access report development and embedding tools Design reports for linking and embedding in applications Format columns, filter data, and add and edit views, including pivot tables and pivot charts Add link functionality to Oracle CRM On Demand and your reports Embed reports using HTML and URL encoding Display rep orts inside dashboards and on home page screens Embed reports inside other reports Add reports and dashboards to custom Web tabs and desktop applications Include external sites in reports.

This first book on the market covering Oracle CRM On Demand reporting delivers comprehensive feature and function information while providing guidance and strategies for report design and development. Real-world case studies, formatting tips, and sample formulas are included throughout. The book will be invaluable to those new to Oracle CRM On Demand as well as seasoned users in need of advanced reporting techniques.

Prepare to pass the OCP Building Internet Applications I ; II exams--two of four required exams for OCP Application Developer certifications--using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Make a smart career move and begin enjoying all the rewards of OCP Financial Applications Consultant certification! This Oracle-endorsed study guide offers a complete preparation system geared to help you pass your exams with flying colors! The design of Oracle Press's OCP series is unprecedented in its level of focus. It provides readers with thorough explanatory text and plenty of examples. Following the main content will be: short chapter review; two-minute drill; 10-15 multiple choice questi ons modeled after the OCP exam questions and answers to chapter questions along with explanations. CD-ROM includes electronic, fully searchable version of the Exam Guide hyperlinked to over 300 practice exam questions.

Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10 and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information. Tailor a system-specific Oracle Collaboration Suite environment Install the Infrastructure Tier, Datastore Tier, and Applications Tier Perform successful migrations to Oracle Collaboration Suite 10g Create, manage, monitor, and delete user accounts with provisioning Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface Perform reliable full and par tial database backups and restores Monitor, analyze, and act on system log files Administer applications, application components, and program functionality Manipulate unstructured data using intelligent containers and Oracle Content Services.

Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10 and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information. Tailor a system-specific Oracle Collaboration Suite environment Install the Infrastructure Tier, Datastore Tier, and Applications Tier Perform successful migrations to Oracle Collaboration Suite 10g Create, manage, monitor, and delete user accounts with provisioning Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface Perform reliable full and par tial database backups and restores Monitor, analyze, and act on system log files Administer applications, application components, and program functionality Manipulate unstructured data using intelligent containers and Oracle Content Services.

Provides and explains powerful scripts that automate common database administration tasks, empowering the DBA to spend more time focusing on the critical aspects of their job.

This 9x6 syntax reference for database administrators explains concepts of backup and recovery and how the Oracle tools work to support those concepts, then presents commands, tables, and flow charts for the Export, Import, and Oracle Data Pump utilities of Oracle 10g; describes the RMAN procedures used to perform everyday tasks that Oracle DBA needs; and offers a reference to the RMAN of Oracle 10g, showing the syntax and options for each command.

Oracle database administration is a complex and stressful job. Pocket guide and quick reference to Oracle DBA, containing easy-to-use checklists for common database administration tasks. Includes coverage of database management, installation and configuration, and network management. Also includes step-by-step quick reference material. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need - and find it fast.

The Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book. This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. Aft er working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator. This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplem ent the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class.

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs). Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy referen ce is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips.

This kit includes three books: Oracle SQL highperformance tuning, Oracle database administration on UNIX systems, and Oracle and UNIX performance tuning. Three CD ROMs included. The complete professional's resource for building, managing, and optimizing Oracle databases! Oracle DBA Reference Library is an unparalleled practical resource for DBAs, database programmers, IT managers, and anyone who needs to make the most of Oracle database technology. It's three comprehensive, up-to-date books by w orld-class Oracle professionals, plus three CD-ROMs packed with tools and information, all for one great price!

Oracle DBA Tips & Techniques is the perfect complement to Oracle Press DBA Handbooks and soon-to-be published Starter Kit. The book is organized and structured to provide time-saving, undocumented methods for the DBAs comprehensive job. The Oracle Tips & Techniques Series is a response to the many requests for this type of material from the readers of Oracle Press. Important features include: "Tips Covered" and "Tips Reviewed" section at the beginning and end of each chapter; easy-refere nce bleed tabs.

Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9i coverage; and iAS - Internet Application Server.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ul timate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame. A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor dat a modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations.

This Oracle Press guide shows you how to take full advantage of RMAN--the robust backup and recovery technology built into Oracle 10g. Oracle Database 10g RMAN Backup & Recovery will serve both as a step-by-step tutorial and an indispensable on-the-job reference that you will refer to again and again. All the latest RMAN features introduced in Oracle Database 10g are covered, including incremental backups, flash recovery area, resetlogs, and much more.

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it's been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author. Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advan tage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more.

This book and CD-ROM package contains everything you need to get started programming on Oracle Database 10g Express Edition. Learn, hands-on, how to develop enterprise applications in PHP which run on Oracle Database 10g Express Edition. The CD-ROM includes a full version of Oracle Database 10g Express Edition with all of the code and solutions from the book.

Grid Computing has at its foundation the necessity that all computing components be readily available at all times, so they can be used when needed. Therefore, the ultimate success of any grid implementation must have at its core the resources to always be up. As such, the Oracle's High Availability offerings are a central component to its future strategy. This will be the first comprehensive book available on this core topic.

Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tun ing. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.

Install and configure Oracle Database 10g on a Linux enterprise platform. This book explains how to set up, administer, monitor, and tune Oracle Database 10g on Linux. You will also learn how to implement High Availability solutions as well as handle backup, recovery, and replication. This exclusive Oracle Press guide is the ideal resource for all Oracle DBAs working in a Linux environment.

Here is an invaluable overview of all the cutting-edge features of Oracle's latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

The Most Authoritative OCA/OCP Exam Guide Available Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you'll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Manag ement and Resource Manager Automate administrative tasks Included on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.

The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book's code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle's Server Technologies Division.

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future per formance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle's XML-enabled products. Includes real-world case studies based on the authors' experience managing Oracle's XML Discussion Forum--a community of 20,000+ XML component users.

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you'll get the fundamentals applicable to all Oracle database releases.

Refined to focus on the newest and most important practical features in Oracle Database 10g, this new edition of the most popular Oracle book of all time will thoroughly cover the most meaningful aspects with a straightforward combination of prose, conceptual diagrams, and code listings.

Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively. This survival guide offers pre viously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases. The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and pr oactively prevent disasters by implementing distributed grid computing-scalable and robust-with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements.

Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements.

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You' ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routin es, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit.

Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.

Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You' ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routin es, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit.

Written by Oracle insiders, Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC, and Data Guard teaches you how to use the latest high availability (HA) products and features in Oracle Database 11g Release 2 to build practical and cost-effective solutions. Based on a DBA-centric approach and providing a conceptual understanding of each topic, the book includes “HA Workshops”—step-by-step instructions to walk you through specific implementatio ns that are inspired by real-world case studies. This Oracle Press guide concentrates on explaining Oracle Database 11g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery. You will learn how to implement an effective HA solution that addresses both unplanned and planned causes of downtime and achieve a truly fault-tolerant infrastructure.

Write powerful SQL statements and PL/SQL programs. Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization tec hniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer. Use SQL SELECT, INSERT, UPDATE, and DELETE statements. Write PL/SQL programs. Create tables, sequences, indexes, views, and triggers. Write advanced queries containing complex analytical functions. Create database objects and collections to handle abstract data. Use large objects to handle multimedia files containing music and movies. Write Java programs to access an Oracle Database using JDBC. Tune your SQL statements to make them execute faster. Explore the XML capabilities of the Oracle Database. Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more.

Write powerful SQL statements and PL/SQL programs. Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization tec hniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer. Use SQL SELECT, INSERT, UPDATE, and DELETE statements. Write PL/SQL programs. Create tables, sequences, indexes, views, and triggers. Write advanced queries containing complex analytical functions. Create database objects and collections to handle abstract data. Use large objects to handle multimedia files containing music and movies. Write Java programs to access an Oracle Database using JDBC. Tune your SQL statements to make them execute faster. Explore the XML capabilities of the Oracle Database. Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more.

This fully revised beginner's guide covers the fundamental concepts of Oracle Database 11g. Through self-paced tutorials, you will learn about database essentials, the role of the administrator, high availability, and large database features. An in-depth introduction to SQL and PL/SQL is also included. Oracle Database 11g: A Beginner's Guide walks you, step-by-step, through database setup, administration, programming, and backup and recovery. A configurable sample database available online prov ides additional support for projects and examples.

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.

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.

Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in the most comprehensive reference available. Starting by establishing critical database concepts and with in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology. The Complete Reference covers SQL, SQL Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java p rogramming in the Oracle environment. The book includes valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All code from the book will be available for download.

Deliver next-generation user capabilities and client-side services in your Oracle-based Web applications by combining the powerful features of AJAX and PHP. Written by Web 2.0 programming experts, Oracle Database AJAX & PHP Web Application Development shows you how to design faster, lighter, more responsive Web applications while reducing code support and creation time. You'll learn how to develop modular AJAX and PHP code, add dynamically updated content, and implement click-to-edit and dra g-and-drop functionality. You'll also get details on incorporating cutting-edge mashup, reporting, and communication features.

Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide.

Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide.

A book/CD-ROM for new and experienced database administrators and managers, reviewing Oracle database architecture and offering step-by- step instructions for planning, sizing, and installing Oracle systems, focusing UNIX-specific configuration and tuning issues. Other topics include security, backup and recovery, and application development. The accompanying CD-ROM contains a multimedia installation and configuration tutorial, readable with any Web browser. Oracle is the leading enterprise data base management system, and more Oracle databases are deployed on UNIX systems than any other platform. There is no introduction to database administration that focuses exclusively on the UNIX platform--this book fills that critical void. The CD-ROM includes a multimedia tutorial on installing and configuring the Oracle server.

This video course contains three-and-a-half hours of QuickTime video instruction plus the Oracle Interactive Workbook e-Book. Caffrey and Scherer (database development and management, Columbia U. School of Continuing Education) present 17 video lectures that cover all key aspects of day-to-day Oracle database administration including creating new datasets; managing physical database layouts; administering users, privileges, and resource groups; tuning Oracle and SQL code for maximum performance; security, auditing, and data integrity; logical and practical backup and recovery; auditing; rollback segments; and other topics.

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor. Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Or acle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them.

The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers.

This guide for using Dataguard technology covers all areas of disaster recovery, standby databases, and automatic Oracle failover. The details of how Oracle10g's improved Dataguard provides a comprehensive solution for disaster recovery while keeping a low TCO are discussed. Descriptions of the concepts and architecture of standby databases as well as the implementation and management of Dataguard are provided. Tips for success in configuration and first-time implementation of Dataguard includin g the internal working of Dataguard Broker and Dataguard with Recovery Manager are revealed.

Provides Oracle Designer professionals with the means to consistently create quality, highly-generated application systems. Authors are experts who frequently give well-attended presentations on this hot topic. Focuses on designing and building systems which optimize the usage of the Forms, Reports, WebServer, and server side generators. This authoritative guide covers releases 2 and 6, providing detailed coverage of the Oracle Designer Forms, Reports, MS Help and Server Side PL/SQL generators. The CD-ROM contains examples from the book, templates, and other useful information for Oracle Designer developers.

Provides a solid understanding of how to plan and build a project that fully realizes the time-saving potential of Designer/2000. Explores the goals, processes, and deliverables for each step in the CASE process. Contains numerous unique tips and techniques; offers tactical "how-to" discussions based on the authors' firsthand experience. This authoritative guide provides a solid understanding of how to design and build a project that fully realizes the time-saving potential of Oracle Designer/20 00. It takes the developer through each step of Oracle's CASE approach, revealing methodical steps and phases of producing software and practical ways that the Designer/2000 tool can support them.

Outlines standards for system development and sets naming conventions for logical and physical objects as well as for data and process elements, and documents recommended conventions for use with the primary diagramming tools found in Oracle Designer. Conventions are presented for the business process modeler, and the function hierarchy, entity relationship and server model diagrammers. The CD-ROM contains a standards document template in Word.

A book/disk package presenting principles of data modeling, GUI design, and coding with SQL and PL/SQL within the context of Oracle's tools, and covering forms, reports, graphics, and tools such as Terminal and Procedure Builder. Appendices list forms object properties, and built-ins for each tool and those common to all Developer/2000 tools. The accompanying disk contains examples from the book, and a shareware version of Barclock. For applications developers with a working knowledge of SQL and relational databases. A tutorial and reference to make up for the lack of hard-copy documentation accompanying the software package itself. Provides step- by-step instructions for every component, including forms, reports, graphics, data modeling, and design tools. Also offers information on Oracle's Web architecture, tuning applications for optimal performance, building graphical user interfaces, and avoiding pitfalls and traps. The CD-ROM contains Developer/2000 sample code plus a full traini ng module.

In a recent Computerworld survey Oracle Developer was second only to Visual Basic in "most-wanted" development tools skills for 1999. Developer's Forms supports a variety of object-oriented features that greatly enhance the productivity of the product, but few developers know how to use these features. This book shows them how. Version 6.0 has been thoroughly debugged and is drawing critical-quality applications in under an hour. CD-ROM includes ready-to-use template and report applications. Dev elop powerful web-based and client/server applications in record time. Maximize the power of Oracle Developer to create sophisticated, flexible, and user-friendly database applications. This unique guide contains an invaluable resource--a discussion of actual Forms and Reports standards used by the authors to create production systems. Included are standards for the use of SQL and PL/SQL in the development tools, naming conventions, and GUI design.

Features real-world applications, undocumented tips, projects, and techniques for developing Oracle Forms. Coverage includes advanced GUI development, advanced forms programming, object-oriented methods, and working with trees. Prerequisites are a working knowledge of Oracle RDBMS and SQL, the PL/SQL language, and Oracle Forms. For developers, IS managers, technical managers, and system analysts. The author is an experienced Oracle Forms applications developer. Designed to help you master advanc ed GUI development, managing multiform applications, error handling, object orientation, Forms intelligence, trees, navigation and validation, and object handling. Provides instruction on how to leverage the power of Forms by combining GUI with programming techniques that create powerful front ends.

Oracle Developer is one of the most powerful database application tools available today, with excellent Internet and middle-tier capabilities. Oracle Developer Starter Kit provides a solid working introduction to using this tool effectively. Stressing a hands-on tutorial of the major features of this product, plus plenty of tips for successful programming, this book is all you need to be productive. The hands-on focus is a real strength of this text, which does a good job of explaining how Orac le Developer works, and offers plenty of advice about following Oracle-recommended conventions. (Readers are reminded that effective Developer programming means cooperating with the excellent built-in functionality of the product. By following a few principles in Developer, you can write database applications that will scale to hundreds or thousands of users effortlessly--this includes the ability to deploy to the Internet.) Early chapters introduce the basics of using Oracle Forms, the form-des ign tool, to create screens for data entry and reports (by using Oracle Reports), along with graphics and charts.

Completely updated for Oracle Discoverer 10g Release 2, this Oracle Press guide explains how to use Oracle Discoverer -- the ad-hoc query, reporting, analysis, and Web -- publishing tool that empowers business users at all levels of an organization to gain immediate access to Business Intelligence. End users will learn to write queries, use the powerful analysis tools, and generate meaningful reports. Administrators will learn how to configure, edit, and use the analytic functions.

Learn to write effective ad hoc queries and perform data analysis easily with Discoverer--Oracle's award-winning, powerful query and analysis tool. This is the only Oracle-authorized guide to this product, from the official Oracle Press. Analyze your organization's Enterprise Resource Planning (ERP) data in order to make informed business decisions using Oracle Discoverer--the award-winning, powerful, ad hoc query and analysis tool. Oracle Discoverer Handbook explains in full detail how end-user s can gain immediate access to information from relational data warehouses, data marts, or online transaction processing systems.

Covering all aspects of Oracle disk I/O tuning, this book explores disk performance, RAID management, Oracle data file performance, and Oracle data segment internals. Also explored is physical disk I/O, which includes disk device internals, detecting disk bottlenecks, disk organization techniques, and disk striping and disk load balancing. Highlighted are RAID and Oracle performance as well as techniques for effective use of RAID with Oracle. Additionally, Oracle data file internals are consider ed and how to use multiple data block sizes to detect and repair Oracle data segment bottlenecks and segment waits is described. Oracle segment management is illustrated, and the effective use of Oracle segment partitioning, segment slot internals, and monitoring segment I/O is explained.

Most organizations that use the Oracle relational database management system (RDBMS) these days need to use multiple databases. There are many reasons to use more than a single database in a distributed database system: Different databases may be associated with particular business functions, such as manufacturing or human resources. Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices. Two different d atabases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse. A busy Internet commerce site may create multiple copies of the same database to attain horizontal scalability. A copy of a production database may be created to serve as a development test bed.

Oracle's version 11i represents Oracle's first presentation of Oracle applications in Internet form, one in which the concept of specific forms loaded as clients or as dumb terminals is replaced by a commitment to industry standard Internet form that should be accessible by anyone anywhere. The book covers the setup and use of Oracle's E-Business Suite 11i including General Ledger, Receivables, Payables, Multi-Org and System Administration. It provides a sample organization from their initial in stallation to the period end close process. Screen shots, business process flow diagrams, and data architecture provide a tutorial for the Oracle applications novice.

From the official Oracle Press comes a comprehensive guide managing, customizing, and tuning this key component of the Oracle Applications Suite. You'll learn to install and update Oracle Financials, apply various patches, and much more using this essential resource.

Implement Oracle's Internet-based Manufacturing and Supply Chain Management products using this Oracle authorized resource. This comprehensive guide explains how to implement the planning, engineering, pricing, order fulfillment, and inventory management components of Oracle Manufacturing and Supply Chain--and develop and deliver goods and services faster, cheaper, and more efficiently than your competitors.

Expertly leverage Oracle technology to protect the enterprise Now you can learn how to maximize the many powerful security features available in Oracle E-Business Suite, Oracle's fully integrated, comprehensive suite of enterprise business applications. You will find out about the key infrastructure, technical, and functional components involved in the secure deployment of Oracle E-Business Suite and how to configure and manage those components for optimum security. A blueprint topology of deplo yment is included. Covers all the security features within release 11 .5. 10 Includes the latest information on SOX, HIPPA, and major international regulatory issues

Here is the first book to tie together the strategies, best practices, and practical approaches to implementing Enterprise Content Management (ECM). You will learn how to gain control of disparate enterprise content and harness intellectual property. The book presents a new, broad approach to ECM that encompasses multiple repositories, corporate-wide document management policies, and true information security.

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide explains in easy-to-follow detail how to administer an Oracle database using this state-of-the-art tool. Inside, you'll learn to eliminate, simplify, and automate administrative tasks and use Oracle Enterprise Manager (EM) as a management framework for your entire Oracle environment.

Centralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, i mplement top-down performance monitoring, and maximize system availability.

Centralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, i mplement top-down performance monitoring, and maximize system availability.

This hands-on guide shows Oracle administrators how to build a robust Grid Control infrastructure through practical, jargon-free instruction and real-world examples. This infrastructure allows you to efficiently manage all of your systems. You will learn to install, configure, and maintain both Oracle and non-Oracle Grid Control products and optimize system availability and performance.

The new edition of this classic book, Oracle Essentials 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracl e's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. More comprehensible than a large reference, and more detailed than mot primers, this book covers all the information you'll need to install and run the Oracle databases, as well as the conceptual background you'll want to understand how they work. If you're new to Oracle or upgrading to Oracle 10g, you'll find this all-in-one guide essential.

The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, 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 command, transparent data encryption, 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 is an enormous system, with myriad technologies, options, and releases. Most users-e ven experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. 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 Database 11g.

The Oracle relational database management system (RDBMS) is an enormous system, with myriad technologies, options, and releases. Most users -- even experienced developers and database administrators -- find it difficult to get a handle on the full scope of the Oracle system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies. This book distills the enormous amount of information about what Oracle i s, where it came from, and what the latest releases (Oracle8 and Oracle8i) do -- and packages it into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints for DBAs and developers. It explains what is new and important about Oracle's revolutionary releases, Oracle8 (the "object-relational database") and Oracle8i (the "Internet database"). It covers such topics as overall system products, architecture, and data structures; installation, management, security, ba ckup and recovery, and tuning issues; and specific Oracle technologies such as data warehouses, online transaction processing (OLTP), and the system's interfaces to the Web.

Oracle Financials Handbook discusses the various products contained in Oracle Financials, with an emphasis on its accounting packages. It provides detailed implementation instructions and expert advice not published elsewhere and offers a blueprint for planning an implementation. Readers will find find essential accounting knowledge within the context of the Oracle products, coverage of key features in each product, and the key issues in successfully installing them. They will also gain a practi cal plan for organizing, budgeting, staffing, and managing an Oracle Applications implementation and will learn about the subtle ways in which package implementation differs from custom software development. This book also addresses when to modify the package to meet business requirements-and when to modify business practices to suit the package.

Oracle Financials Handbook discusses the various products contained in Oracle Financials, with an emphasis on its accounting packages. It provides detailed implementation instructions and expert advice not published elsewhere and offers a blueprint for planning an implementation. Readers will find find essential accounting knowledge within the context of the Oracle products, coverage of key features in each product, and the key issues in successfully installing them. They will also gain a practi cal plan for organizing, budgeting, staffing, and managing an Oracle Applications implementation and will learn about the subtle ways in which package implementation differs from custom software development. This book also addresses when to modify the package to meet business requirements-and when to modify business practices to suit the package.

The Ultimate Reference & Learning Guide for Oracle Financials Consultants! Over 150 Certification Questions, Answers, and Explanations It's clear that Oracle Financials is the future for ERP in Oracle - but finding good reference materials can be difficult. Now, for the first time, a world class Oracle consultant shares his knowledge and understanding of this complex topic. Oracle Financials Interview Questions guides you easily through your learning process. From helping you to assess your Oracle Financials skills, to helping screen candidates for your Oracle positions, Oracle Financials Interview Questions will help you understand what you really need to know. This book is organized around several areas of Oracle Financials: General Ledger, Accounts Payable, Accounts Receivable, OFSA, Budget module, Technical installation & configuration, Procure to Pay. In addition, Oracle Fusion Middleware is covered. Each question is based on implementation project know-how gained on high- profile Oracle Financials implementations. Key topics include: Fusion Middleware, General Ledger, Budget, AR/AP, Technical installation & configuration, Procure to Pay, much more.

Oracle Forensics will delve deep in the guts of undocumented Oracle features and show where to find the digital footprints left by an attacker. It will show how to: 1) Hunt for digital evidence by dissecting the Redo Logs and locating dropped and deleted objects; 2) Study disparate log files and audit trails to build accurate timelines of events; 3) Work out how an attacker broke in and how to keep them out; 4) Perform a forensic analysis using scenarios based upon real world incidents

Instructions on proactively ensuring the safety and security of Oracle data are found in this innovative guide to Oracle Forensics techniques. Packed with insights and expert tips, this definitive reference provides strategies for protecting critical data from a variety of outside threats and for boosting the overall effectiveness of Oracle firewalls. Additional instructions for developing an automated framework for accessing database security make this required reading for any Oracle database a dministrator.

A step-by-step guide to the forms of Oracle 6i, from debugging and coding to project management and object-oriented analysis and design. Shows how to build GUIs that deliver breakthrough ease of use, create integrated Developer/2000 applications, and access the full power of Windows and other support programs. Oracle Forms is the most important tool used to create client/server and World Wide Web applications that run against Oracle databases. Oracle Forms Developer's Handbook is a complete refe rence guide for those who use Forms to build sophisticated database systems rapidly and productively. The book covers in detail all the aspects, features, and functionality of Oracle Forms.

This video course contains four-and-a-half hours of QuickTime video instruction as well as the Oracle Forms Interactive Workbook e-Book that integrates the tutorials with hands-on practical exercises, self-review questions, and real-world labs. The 13 video lectures cover topics including Oracle Forms development environment, form builder, reusable objects and code, triggers and built-ins, LOVs and alerts, canvases and windows, multiple form applications, and integration with Oracle reports. Req uires a basic understanding of the Oracle 7/8/8i database, SQL, PL/SQL, and database design. Prepared by Rosenzweig (consultant for Oracle Corporation) and Motivala (former Oracle Tools employee and Forms instructor.

The Oracle Forms Interactive Workbook presents Oracle Forms in a unique and highly effective format. It challenges you to learn Oracle Forms by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle Forms workbook teaches you about Forms, triggers, and items by first showing you examples and then asking you to create these objects yourself. This book is inte nded for anyone who needs a quick but detailed introduction to building applications with Oracle Forms. The ideal readers are those with some experience with relational databases, specifically Oracle, but little or no experience with Oracle Forms or application development.

Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount. Your days of dismay over the lack of documentation over Oracle GoldenGate are ove r. Welcome to Oracle GoldenGate 11g Implementer's guide - a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.

Even if you have limited programming experience, you can develop and deploy professional-quality applications using Oracle's new rapid web application development tool. Oracle HTML DB Handbook shows you how to quickly create secure and scalable web applications that can be instantly deployed. Learn how you can consolidate spreadsheets and desktop databases into an Oracle Database and share your applications over the web. You'll also get details on administration and security. Real-world sample p rojects get you started using Oracle HTML DB right away.

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.

From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Handbook for Oracle STATSPACK users, to making informed performance and tuning decisions for a system, based on data gathered with the utility. Shows how to perform trend analyses, locate and tune SQL statements, tune the server environment, including the CPU and RAM, and detect and correct performance problems.

Oracle designed its database products to be flexible and configurable so they would operate on a variety of hardware platforms, and they succeeded--Oracle software runs on more than seventy computer platforms, from mainframes to PC networks to handheld PDAs. The secret to this flexibility lies in the software's initialization parameters, whose numerous settings can be configured for top performance in countless environments. On the downside, however, improper settings can slow a system down; eve n grind it to a halt. And with so many parameters--which change from version to version of Oracle software--it's challenging for Oracle administrators to keep in mind the characteristics and optimal settings for each parameter. The Oracle Initialization Parameters Pocket Reference provides the crucial information you need to make key adjustments to your Oracle database. This concise guide is a mix of invaluable performance tips and a quick reference to Oracle's initialization parameters. The boo k describes each initialization parameter, indicates what category it's in--from auditing to multi-threaded server MTS--and whether it can be modified dynamically via the ALTER SESSION or ALTER SYSTEM command. In addition to the details about parameter characteristics and settings, you'll find performance tips, such as how the various parameters interact, and what the most advantageous settings are for different configurations. No other reference focuses exclusively on these initialization param eters--an absolute must for anyone working with an Oracle database. Presented in a handy, easy-to-use format, the Oracle Initialization Parameters Pocket Reference is a welcome alternative for anyone who's struggled to memorize the best configuration settings or gone back and forth to online resources, trying to figure out what works. O'Reilly's Pocket References put the information you need close at hand where you need it most. This guide will keep your Oracle databases operating at peak perfor mance.

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.

This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches.

This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches.

An exclusive from Oracle Press! The Oracle Tools Division is expanding its Java strategy, making this book timely and pertinent. Packed with current screen shots, this book guides database application developers in building cross-platform Java apps; web-delivered Java applets; and JavaBeans--no previous Java experience needed! Covers the new DataForm Wizard and SQLJ. A revision of, "JBuilder Essentials", this repackaged title focuses on teaching database application developers to develop sophist icated, cross-platform Java applications, Web-delivered Java applets, and JavaBeans--all with no prior Java experience necessary.

Create web and database applications with Oracle JDeveloper 10g--the complete, integrated Java development environment--with help from this comprehensive, real-world resource. Many chapters contain hands-on practices and source code examples reinforcing vital concepts. It's all here--from the nuts-and-bolts of J2EE applications, servlets, and JavaServer Pages technology to advanced development using the Oracle Application Development Framework. From the exclusive publishers of Oracle Press books , Oracle JDeveloper 10g Handbook will have you developing Java-based applications in no time.

The most efficient way to learn J2EE programming techniques. Two Oracle experts demonstrate techniques for working within J2EE and JDeveloper for the thousands of developers currently using Oracle Forms and the PL/SQL language. Oracle is shifting their focus towards Java technologies, so you will need to know how to use the Java-based J2EE and JDeveloper. The book includes explanations of the Application Development Framework (ADF). Throughout, high-level and low-level Forms concepts are related to Java concepts so that you can become comfortable with the new terminology. Covers the new components required when developing and deploying a J2EE application Special callouts note how JDeveloper techniques translate to PL/SQL or Oracle Forms All code and examples will be available online.

From the official Oracle Press comes a thorough guide to Oracle JDeveloper 3--the complete and integrated Java development and deployment environment. This book explains how to use JDeveloper in combination with an object-oriented approach to database design. In addition to an overview of the tool, the book covers the following JDeveloper components and how these can be successfully integrated into production applications: Applets, Servlets, CORBA, JavaBeans, and Enterprise JavaBeans

The product of interviews with hundreds of Oracle professionals, this thorough guidebook provides useful insight into what characteristics make a good database administrator, offering helpful techniques to use while interviewing candidates for an Oracle DBA position. By using Oracle job interview questions that only an experienced person would be familiar with, employers can employ this incredible collection to ensure that their interviewer asks the right questions and hires the best-qualified D BA or developer available. A full set of Oracle job interview questions and a complete method for accurately assessing the technical abilities of Oracle job candidates are provided.

Net8 is the fundamental Oracle technology that allows Oracle services and clients to communicate with each other over a network. Net8 is most often used to connect client software to Oracle database servers. It may also be used to connect database servers to one another, allowing communication between distributed databases. This practical guide provides the information that readers, especially database administrators, need to know in order to install configure, tune, and troubleshoot Net8.

PL/SQL is Oracle's version of SQL, the industry standard for enterprise-level database interaction. Explains how to write powerful, flexible programs, and to automate a multitude of database tasks. The only official Oracle entry-level book on the topic, it provides a complete introductory course to readers on SQL and PL/SQL. An invaluable tool for database administrators, developers and financial analysts, it teaches novice-through-experienced readers how to manipulate records to easily access a nd analyze database information. Popularity of SQL, combined with rich response to Oracle Press' other SQL titles, make this respected resource a guaranteed best-seller.

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, an d chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, p ackages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

The Oracle PL/SQL Interactive Workbook presents the Oracle PL/SQL programming language in a unique and highly effective format. It challenges you to learn Oracle PL/SQL by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle PL/SQL workbook teaches you about cursors, procedures, and triggers by first showing you examples, and then asking you to create thes e objects yourself. Is For This book is intended for anyone who needs a quick but detailed introduction to programming with Oracle's PL/SQL language. The ideal readers are those with some experience with relational databases, with some Oracle experience, specifically with SQL and SQL*Plus, but with little or no experience with PL/SQL, or with most other programming languages.

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques. Integrated book-and-Web learning solution teaches all of the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and the Web-based training site.

The Ultimate Reference & Learning Guide for Oracle PL/SQL Over 100 PL/SQL Interview Questions, Answers, and Explanations It' s clear that Oracle is the future for enterprise information systems, and finding resources can be difficult. Oracle PL/SQL Interview Questions Answers, and Explanations guides you through your learning process. From helping you to assess your Oracle skills to evaluating candidates for a job, Oracle PL/SQL Interview Questions, Answers, & Explanations will help you understand what you really need to know. The book is organized around Programming, Troubleshooting, and understanding PL/SQL. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile Oracle implementations.

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor managem ent, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

New edition which adds chapters describing PL/SQL in terms of object features and tuning, and includes expanded discussions of debugging and tracing execution. Twenty-six chapters discuss topics including programming, language elements, built-in functions, modular code, and new PL/SQL8 features. The included disk contains the Oracle PL/SQL programming utilities guide which offers approximately 100 files of source code and documentation. Packed with examples and recommendations, it helped everyon e using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language.

This workbook is a companion to Steven Feuerstein's bestselling books, Oracle PL/SQL Programming (considered the bible for PL/SQL developers), Oracle Built-in Packages, and Advanced Oracle PL/SQL: Programming with Packages. The workbook provides a carefully constructed set of exercises that test PL/SQL developers' language skills and help them become better programmers. Exercises are provided at three levels: beginner, intermediate, and advanced; in this way, the book is suitable for complete be ginners, yet continues to be useful as readers gain mastery of the PL/SQL language.

New edition which adds chapters describing PL/SQL in terms of object features and tuning, and includes expanded discussions of debugging and tracing execution. Twenty-six chapters discuss topics including programming, language elements, built-in functions, modular code, and new PL/SQL8 features. The included disk contains the Oracle PL/SQL programming utilities guide which offers approximately 100 files of source code and documentation. Oracle PL/SQL Programming has been an indispensable refere nce for both novice and experienced PL/SQL developers since its first edition. Now in its third edition, the book has been thoroughly revised and updated to include the latest Oracle releases (Oracle8i and Oracle9i) the "Internet databases" that communicate with other technologies, such as Java, to run powerful e-commerce applications.

If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions a bout how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution. Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Fe uerstein mentions language elements of interest.

Oracle8i, the long-awaited "Internet database" from Oracle Corporation, is finally in production, and it offers a wide array of powerful features, including Web and Java technologies inside the database. The Oracle Internet File System (iFS), a Java Virtual Machine in the database, JDeveloper (a Java integrated development environment), Java stored procedures, the WebDB and interMedia tools, and much more, are now available to Oracle developers. And these developers are starting to realize how m uch they have to learn. This book is a companion to Steven Feuerstein's bestselling Oracle PL/SQL Programming (the second edition of that book is current for Oracle8). The companion book provides a very helpful transition for PL/SQL developers who are new to Oracle8i. It describes the new PL/SQL features available in Oracle8i (e.g., autonomous transactions, the invoker rights model, native dynamic SQL, and bulk binds and collects). It also covers features that allow PL/SQL developers to interfac e with Java and to do Web-based development. In addition, it includes a host of performance improvements available in PL/SQL under Oracle8i.

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 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.

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing techniques to achieve high performance. Ready-to-use tips for saving hardware costs by running applications at peak efficiencies are provided for senior Oracle DBAs and developers, and powerful PL/SQL techniques are outlined.

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.

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

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur. Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Coverin g the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples. Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM, DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming. DB As who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to O LAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, suc h as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards tha t can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to O LAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, suc h as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards tha t can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

This video course contains three-and-a-half hours of QuickTime video instruction together with the Oracle PL/SQL Interactive Workbook e-Book. Silvestrova, Rosenzweig and Scherer (database development and management, Columbia U. School of Continuing Education) present 16 video lectures that cover Oracle PL/SQL techniques and concepts including syntax, structured programming, and iterative control; scoping and anchored datatypes; exception handling; scoping, cursors, packaged code, and triggers; a dvanced topics such as stored code, package and parameter passing, and more.

If you're a DBA who's looking for real world Oracle tuning techniques, Oracle scripts, and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Written by one the world's top DBAs and Oracle internals experts, Robin Schumacher focuses his incredible knowledge of the Oracle data dictionary into a superb book that show how to quickly troubleshoot and correct Oracle performance problems. As a Vice President at Embarcadero Technologies, Rob in Schumacher has written the internals for some of the world's most powerful Oracle performance software and now he shows you how to use the most recent advancements in Oracle8i and 9i to make your Oracle database run as fast as possible.

Tuning is crucial for complex relational database management systems. This guide shows managers, programmers, and administrators the alternatives to throwing money at performance problems (for buying larger and more expensive computers or hiring expert consultants). A guide to improving the performance of the Oracle relational database system. Addresses initial equipment and configuration decisions; how to get the best performance out of programs focusing on SQL, PL/SQL, and locking strategies; using memory and disk space efficiently; and long-running job, client-server environment, or system specific tuning. Additionally contains six appendixes containing summary material of relevance.

Edward Whalen is vice president and founder of Performance Tuning Corporation (perftuning), a consulting company that specializes in database performance, administration, and backup/recovery solutions. He has extensive experience in database system design and tuning for optimal performance. His career has consisted of hardware, operating system, and database development projects for many different companies. Edward has published two other books on the Oracle RDBMS. He has also written four books on Microsoft SQL Server. In addition to writing, Edward has worked on numerous benchmarks and performance-tuning projects with both Oracle and MS SQL Server. Mitchell Schroeter is a senior consultant with Performance Tuning Corporation (perftuning) and has worked in the field of database performance tuning for five years. Prior to Performance Tuning Corporation, Mitchell worked at Dell Computer Corporation as a systems analyst in the systems performance analysis group, specializing in database technologies and high-performance storage systems. He has extensive experience with developing client-server and multitiered applications on both Oracle and Microsoft SQL Server in a variety of programming languages. Mitchell specializes in tuning database systems and application code, storage area networks, and Oracle 9i Real Application Clusters.

Expert Technical Knowledge at the Turn of a Page. Tune and tailor your Oracle7 or Oracle8 system to perform at its peak using this one-of-a-kind reference, designed for every Oracle database administrator, programmer, and user. In Oracle Performance Tuning Tips & Techniques, you'll find hundreds of real-world examples and insider secrets compiled from TUSC's standing-room only conference presentations and Oracle User Groups worldwide. From finding and fixing bottlenecks to enhancing performa nce using PL/SQL, this authoritative guide reveals proven methods for getting the most from your Oracle system throughout its lifecycle. Discover the Top 10 Tuning Tips used by industry experts to improve performance Maximize tuning with the most important basic, advanced, and undocumented INIT.ORA parameters for Oracle7 and Oracle8 Use Explain Plan and Tkprof to uncover problem queries that, when corrected, result in peak performance Explore the new features in Oracle8 to gain peak performance by uncovering problem queries Refine your tuning skills by exploring the new features in Oracle8 Take advantage of key V Views and X Tables to enhance performance Developed through years of consulting expertise, Oracle Performance Tuning Tips & Techniques is packed with time-saving tuning gems designed to ensure top system performance.

Sharing secrets for the effective creation of auditing mechanisms for Health/Insurance Portability and Accountability Act of 1996 (HIPAA) compliant Oracle systems, this book demonstrates how the HIPAA framework provides complete security access and auditing for Oracle database information. Complete details for using Oracle auditing features, including auditing from Oracle redo logs, using system-level triggers, and using Oracle9i fine-grained auditing (FGA) for auditing of the retrieval of sensi tive information, are provided. Examples from all areas of auditing are covered and include working scripts and code snippets. Also discussed are the use of the Oracle9i LogMiner to retrieve audits of database updates and how to implement all Oracle system-level triggers for auditing, including DDL triggers, server error triggers, and login and logoff triggers.

Oracle R12 Applications DBA Field Guide is the second edition of the guide updated to provide the details needed to administer Oracle E-Business Suite Release 12. The book includes guidelines and references to guide you through the management and deployment of Oracle Applications Release 12. Included in the guide are topics ranging from architecture, configuration, installation, cloning, patching, monitoring, troubleshooting to performance tuning. The new edition provides essentials for administ ering the updated Applications tier and technology stack, including Oracle 10gAS and Oracle Database 11g. Even for the experienced database administrator, Oracle Applications are complicated to administer, and most documentation that is available is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a new to Oracle Applications, (perhaps experienced with PeopleSoft, JD Edwards, or Siebel), this book will enable and ease the administration and efficiency of your day-to-day tasks.

This guide to leveraging RAM-SAN technology shows Oracle DBAs how to create fast Oracle9i RAC databases. Techniques for leveraging RAM disk in an Oracle RAC and Grid environment are demonstrated including changes to initialization parameters and the selective use of SSD in large database environments (UNDO, REDO, and TEMP tablespaces on solid-state disk).

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.

Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC. This book provid es comprehensive coverage of the features, technology and principles of RAC that is part of the Oracle9i release of Oracle's RDBMS product. It is divided into three main parts: application/database design, development and maintenance life cycles. Compared to its predecessor OPS, the architecture behind RAC implementation have changed significantly. Vallath discusses Oracle9i features in a RAC implementation with respect to usage and design considerations, as well as those parameters that are an d are not applicable. Areas covered include partitioning, indexes, tablespace management, transaction management, backup and recovery principles.

Learn cutting-edge technology from Oracle experts Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online.

Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data. This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages. O'Reilly's Pocket References have be come a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

With the advent of inexpensive and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data. However, Oracle multi-master replication is extremely complex and time-consuming to implant. This book addresses the complexity of Oracle replication by providing working code examples and illustrations of working systems. Demonstrated is every aspect of Oracle snapshot replication including syntax for refresh intervals, managing snapshot logs, monitoring oracle replication, and refresh timings. Included is a description of the intricacies of Oracle multimaster replication tuning and monitoring. Also detailed are techniques for implementing conflict resolution in multi-master replication.

SAP is the leading vendor of enterprise resource planning (ERP) systems in the world. (The name SAP is an acronym for the German "Systemanalyse und Programmentwicklung", which roughly translates to "Systems, Applications, and Products in Data Processing".) Developed and marketed by SAP-AG, a Germany company that was founded in 1972 by IBM application developers, SAP has historically sold to the European market. During the 1990s, the company has increasingly dominated the U.S. market as well amon g large Fortune 500 companies. Nearly half the SAP user base is now in the U.S. Now that SAP-AG is beginning to penetrate the small to medium-size companies, client/server sales are accelerating. The SAP system performs a wide range of business functions, from manufacturing, sales, and distribution to accounting and human resources. By linking together these business functions, SAP helps the entire enterprise run more smoothly. The system can be used with virtually any hardware or operating syst em and with most database systems. Oracle is the dominant DBMS - about 80% of SAP systems use Oracle. Conversely, about 20% of large Oracle sites run SAP -- and the numbers are growing. Although overall SAP numbers are tightly guarded, it appears that there are about 20,000 SAP sites, in 90 countries. SAP-AG's 1998 sales were approximately 8.47 billion.

In Oracle SQL & PL/SQL Annotated Archives, authors Loney and Carmichael have assembled a topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Although this book is not by any means a tutorial for the database's programming language, even skillful database administrators can learn much from the illustrated techniques. The book begins with a chapter of Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributi ons across table and index partitions, and others. The rest of the chapters are devoted to particular topics. The first section addresses performance management and includes several scripts for collecting statistics and managing the System Global Area. These performance-related scripts are extremely valuable for any developer. Next comes a series of scripts related to monitoring transactions, diagnostic utilities to analyze data definition, and similar scripts for managing objects and space. Th en it's on to diagnostic and utility scripts for managing users and some general database scripts. The book wraps up with a lengthy appendix that serves as an excellent reference to the PL/SQL language. Each chapter begins with summary of its scripts, and they are also included on the CD-ROM. Explanatory text is clearly identified as annotations, but the majority of the book consists of highly technical reading. While this book does not make for a very entertaining read, it provides Oracle admi nistrators with powerful tools they can turn to in a pinch.

A guide for Oracle developers and database administrators, covering every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes designing applications to maximize efficiency, building indexes, identifying and resolving Oracle Server bottlenecks, fixing poorly performed SQL code, and leveraging Oracle's parallel query facility.

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program.

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions.

SQL*Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQL*Loader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format. Almost every Oracle user has to use SQL*Loader at one time or another, and DBAs are frequent ly called upon to load data for the users in their organization. Despite SQL*Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL*Loader: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader tasks you'd want to perform - and maybe some you didn't realize you COULD perform.

This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries . It also contains quick references to the SQL*Plus commands and format elements.

The Oracle SQL*Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the Oracle SQL*Plus Pocket Reference to be extremely beneficial. The new third edition of this book has been updated for Oracle Database 10g to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN. With its quick-reference format and compact size, the Oracle SQL*Plus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ide al companion to O'Reilly's larger, more comprehensive book on SQL*Plus, the bestselling Oracle SQL*Plus: The Definitive Guide. Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.

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.

As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book's timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the intern als of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.

Introduces the basic relational database terminology and techniques for extracting information from Oracle databases. Written for beginners, the book focuses on the SQL*Plus query language and the SELECT command for querying a database. Business objects and data warehouses are briefly covered. The final three chapters overview the PL/SQL programming language. The CD-ROM contains a practice database and sample scripts

This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book b oils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements.

This book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQL*Plus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQL*Plus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, in cluding Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is.

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user. The new second edition of Oracle SQL*Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe so me you didn't realize you could perform. It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction. This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subquerie s, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

SQL (Structured Query Language) is the heart of a relational database management system. It's the language used to query the database, to create new tables in the database, to update and delete database fields, and to set privileges in the database. Oracle SQL: The Essential Reference is for everyone who needs to access an Oracle database using SQL--developers, DBAs, designers, and managers. SQL is based on research dating back to the late 1960s, but its first commercial release was in the RDBMS announced by the fledgling Oracle Corporation in 1979. Since that time, every other database vendor has adopted SQL, and ANSI and the ISO have made it a standard. Although vendors diverge in their extensions to SQL, the core language is standard across vendor boundaries.

This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBA s and developers find themselves reinventing the wheel by writing the same kinds of scripts -- and too often they're writing them under pressure, in hit-or-miss and error-prone fashion. The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. You can use them right now to simplify the tasks you perform each day -- monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and bui lding reports that provide insight into the inner workings of Oracle databases. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on.

This book covers the field of Oracle security from simple to complex. It describes basic RDBMS security features (e.g., passwords, profiles, roles, privileges, synonyms) and includes many practical strategies for securing an Oracle system, developing auditing and backup plans, and using the Oracle Enterprise Manager and Oracle Security Server. Also touches on advanced security features, such as encryption, Trusted Oracle, and Internet and Web protection. This unique book extensively discusses ba sic RDBMS security features, such as system file and password protection, database table and field access control, and the use of audit trails and backup and recovery strategies. It also offers many practical strategies for securing an Oracle system and touches on advanced security features.

Develop and Execute a Fail-Safe Security Plan for Your Oracle System. Opening mission-critical systems to partners and customers over the Internet poses new challenges to traditional measures of enterprise security. Oracle Security Handbook presents tested techniques and proven strategies for securing an Oracle environment -- from the operating system to the database to the network. You'll get step-by-step details on developing a rock-solid security plan and concrete examples of how to implement security using Oracle's built-in tools. The book also explains how to hacker-proof, audit, and troubleshoot your entire system. Officially endorsed by Oracle Corporation, this expert resource even delves into the details of Oracles own security implementations.

With the expert techniques discussed in this book, Oracle database administrators can automate routine tasks to save time and money and better monitor the flow of work. Using shell scripts-an indispensable tool on UIX and Linux-any number of commands can be combined and executed either simultaneously or sequentially. More than 50 working shell scripts for both beginners and experts give Oracle professionals a fantastic head-start on automating their administration duties and are easily modifiabl e for any environment. Topics include the history of shells and shell scripting, detailed step-by-step instructions on building shell scripts, how to tell when things are working right, and how to effectively monitor the system for failures.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD- ROM features a set of tools for detecting and correcting SQL bottlenecks.

Master Oracle Streams 11g Replication Enable real-time information access and data sharing across your distributed framework using the expert information in this Oracle Press guide. Oracle Streams 11g Data Replication explains how to set up and administer a unified enterprise data sharing infrastructure. Learn how to capture, propagate, and apply database changes, transform data, and handle data conflicts. Monitoring, optimizing, and troubleshooting techniques are also covered in this comprehen sive volume. Understand Oracle Streams components and architecture Gain in-depth knowledge about capturing, propagating, and applying data manipulation language (DML) and data definition language (DDL) changes Learn how to access and modify the contents of Logical Change Records Build custom procedures for data transformations Configure Oracle Streams replication for the database, schemas, and tables Tune Oracle Streams performance for improved throughput Manage and monitor Oracle Streams usin g Oracle Enterprise Manager Grid Control Learn from several practical examples and scripts.

Master Oracle Streams 11g Replication Enable real-time information access and data sharing across your distributed framework using the expert information in this Oracle Press guide. Oracle Streams 11g Data Replication explains how to set up and administer a unified enterprise data sharing infrastructure. Learn how to capture, propagate, and apply database changes, transform data, and handle data conflicts. Monitoring, optimizing, and troubleshooting techniques are also covered in this comprehen sive volume. Understand Oracle Streams components and architecture Gain in-depth knowledge about capturing, propagating, and applying data manipulation language (DML) and data definition language (DDL) changes Learn how to access and modify the contents of Logical Change Records Build custom procedures for data transformations Configure Oracle Streams replication for the database, schemas, and tables Tune Oracle Streams performance for improved throughput Manage and monitor Oracle Streams usin g Oracle Enterprise Manager Grid Control Learn from several practical examples and scripts.

Revealing secrets for achieving high-speed replication and data sharing, this guide uses proven techniques from mission-critical applications for ensuring success with Oracle Streams. From installation to implementation, step-by-step instructions are provided to ensure success with these powerful Oracle features. Oracle DBAs are walked safely through the myriad of complex Oracle Streams tasks including the set-up of the staging area queue, propagation through data hubs, customized apply function s, rule-based data propagation, and Oracle Streams transformation.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

For Oracle tuning professionals wishing to add more tools to their Oracle tuning toolbox, this guidebook introduces the various tuning analytical tools and helpful strategies to make the database easier to use. Details describe how to extract information from the database and use it to determine and increase efficiency. It also provides specific steps with detailed information on how to congeal large amounts of database performance information into one pool from which the DBA can carefully choos e tuning options based on what is predicted, all to give them the biggest improvement in performance for the least time and money investment. Sample code, sample code results, and guidelines on how to interpret the results help users manipulate code in an effective way. With countless hints, tips, and tools, the guide fully explains how to work with the Oracle system on order to achieve database performance excellence.

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day. As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. Packed with information in an easy-to-read format, this valuable resourc e is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand. Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books.

Targeted toward experienced Oracle professionals who need to perform powerful system-wide operating system on their Oracle databases, this definitive guide includes details on all of the Oracle utilities, including an experts-only section on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. Approaching Oracle Utilities from a functional perspective, this guide adds value by explaining the "why" and "how" for the use of all Oracle Utilities. Additionally, the book also covers Oracle tuning utilities and all areas of Oracle database administration, including ADDM and the SQL tuning advisors and the traditional command-line tuning utilities, as well as secrets for database migration, and detailed tips for using Oracle OS utilities.

Targeted at seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases, this book provides help on how to use the utilities provided with the Oracle database. Explained are secrets for database migration with export/import and SQL*Loader utilities as well as OS utilities such as dbverify, orastack, and orakill. Tuning utilities including tkprof and dbms_debug are described in detail in addition to monitoring utilities inc luding dbms_alert and dbms_xplan. Also covered in the book are network and developer utilities.

This handbook provides database administrators with clear and concise processes with which to attack tuning problems using Oracle Wait Interface. A guide is provided to demonstrate the mechanics of the Wait Interface and how to use it not only to tune database performance at the database level but also to give the statistics needed to understand problems that lie outside of the database in the SAN or the network. Techniques that apply to tuning any Oracle database from version 7 through 9i and b eyond are included.

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

This compact guide provides the jump-start Oracle developers need to make the transition from traditional programming to the development of useful Web applications for Oracle8i. Even readers who start out knowing nothing about HTML, PL/SQL, or Oracle's other tools will learn how to create simple Web applications in a matter of days. The book focuses on Oracle8i, but also covers Web development for earlier Oracle versions (Oracle8 and Oracle7).

Oracle's new run-anywhere browser-based tool delivers everything you need to deploy powerful database applications over the Internet. And this authoritative reference delivers everything you need to master the complete capabilities of WebDB -- database browsing, application development, component management, performance monitoring, even constructing entire Web sites with SiteBuilder. Written by two veteran database applications developers who were key contributors to the WebDB beta program, this encyclopedic guide will help you extend the rich functionality of WebDB -- and realize the full potential of your Web site.

Oracle Workflow allows Oracle E-Business Suite users to automate and continuously improve business processes, routing information of any type--according to easily modifiable business rules--to people inside or outside an organization. By using Oracle Workflow, businesses can get the most out of their multimillion dollar investments in Oracle E-Business Suite. Oracle Workflow Handbook begins by covering the setup of both the Oracle Workflow client and server. Using sample business issues and cas e studies, the book walks you through the implementation, development, and administration of Oracle Workflow including advice on defining best practices, debugging, and troubleshooting.

From the only official publisher of Oracle Press books comes this unique resource--Oracle XML Handbook. This one-of-a-kind reference explains the XML standard, how to create XML documents, and how XML will transform legacy systems integration involving e-commerce initiatives. As more corporations migrate to an eBusiness model using Oracle8i--THE database for Internet computing--it's crucial for all of you Web developers to learn to use XML in the Oracle environment. This is your book.

A book/CD-ROM package on tuning both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they run on, and on optimizing both OLTP and OLAP decision support systems. Presents a systematic approach to tuning Oracle databases based on UNIX, reviews UNIX kernal-related issues, and introduces techniques for tuning memory, processors, and I/O. Also covers optimizing SQL code. The companion CD-ROM contains tuning tools. Assumes basic understanding of SQL, UNIX shell lang uage, and database administration.

Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities. The goal of Oracle in a Nutshell is to bring order to the chaos of Oracle informatio n -- to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security admini strators need as they manage Oracle databases and write code for these databases.

Oracle Senior Performance Engineer Ahmed Alomari covers virtually every relevant optimization technique in Oracle8, Oracle7, and three leading versions of UNIX: Solaris 2.6, HP-UX 11, and Sequent Dynix-ptx 4.4. He presents in-depth coverage of both OLTP and DSS applications, covering optimization of the UNIX kernel, memory, processors and I/O, and all these major Oracle8 performance enhancements.

Picks up teaching Oracle skills where Oracle8 DBA Handbook and Tuning Oracle leave off. Gives Oracle8 DBAs the advanced tools necessary to manage and tune their databases regardless of the rate of growth in the environment--a very important scalability skill. Revised to cover all new aspects of Oracle8, including: Partitioned tables, abstract datatypes, index-only tables, objects, and more. CD-ROM includes code from the book, plus a new version of SQLab--a valuable application tool that help rea ders practice advanced optimization techniques. The previous edition sold over 25,000 copies, and this new version gives Oracle8 DBAs the advanced tools necessary to manage and tune their databases regardless of the rate of growth in the environment. The CD-ROM includes code from the book plus a new version of SQLab.

The book design has two primary goals. First, the book is a basic/intermediate level presentation of the primary concepts and software architecture of Oracle8. After reading this book, any type of Oracle8 user will have a solid, big-picture understanding of how Oracle8 fits into the world of serious data management applications. Second, the book is an excellent planning guide that will help a current Oracle user server to migrate Oracle7 databases and corresponding database server administrators and application developers need to understand to work with Oracle8.

This edition, revised for Oracle8, focuses exclusively on issues related to backup and recovery. Complete coverage is given of Oracle on NT and the new object-oriented database features. The book also explores common user errors encountered with Oracle8 and how to fix them. Rama's book (like the rest of his other ones) is a life-saver. He has a unique way of presenting pertinent information (which otherwise could have been obtained the hard way) to the DBA. His writings on Oracle are the finest pieces out there now. He evokes the why's, what's and how to's with such clarity and accuracy that he implicitly brings added value to any DBA's overall ability and confidence level. It is a MUST HAVE.

Specially designed and written to help you pass the Oracle8: Network Administration (1Z0-016) exam, Oracle DBA Network Administration Exam Cram is packed with time-saving study tips, test-taking strategies, and warnings on how to deal with trick questions. Includes a sixty-two question sample test with answer key and a special CRAM SHEET with tips, acronyms, and memory joggers with help you pass the exam the first time. Oracle DBA Network Administration Exam Cram will help you learn how to use t he Net8 Assistant; configure local naming; configure host naming; configure an Oracle Names Server; set up connection pooling; configure LISTENER processes; set up multiple LISTENER processes on a server; configure client profiles; set parameters for MTS; monitor MTS processes; set up connection; start, stop, and monitor LISTENER; configure Intelligent Agent; start, stop, and monitor Intelligent Agent; implement security with Net8; troubleshoot Net8 problems on the client and the server, use the Connection Manager.

The first book available on Oracle8 Data Warehousing. Authored by the Oracle industry respected, best-selling author team of Abbey, Corey, Abramson, and Taub. Provides readers with a fundamental understanding of Data Warehousing and shows them how to implement the concept to their database environment. Includes coverage of Oracle's Express (analyzer) tool and other third-party tools. New chapters have been added to cover Oracle8's new and improved Data Warehousing features-new coverage includes: Data Warehouse design, data transformation techniques, partitioning, ROLAP and Aggregate Navigators, and OLAP tools.

Written for database administrators, this text covers architecture, installation, tuning, security, networking, and the basics of application development with PL/SQL. Addressing the fundamental enhancements that have been made to Oracle7, this title covers installation of Oracle8 on the Windows NT platform. The CD-ROM contains a trial version of DBAWare, a database performance and analysis tool from MenloSoftware.

Approved and authorized by today's leader in enterprise database technology, and available only from Osborne! No one covers Oracle in such depth and breadth, and with such proven success--over 300,000 Oracle Press books sold in 1997 alone! Oracle8's cutting edge object technology rewrites the rules of efficient database design--and will send thousands of experienced DBA's looking for expert advice; covers object and relational database and code design--including data models, denormalization, key s and indexes, special architecture and data warehousing; only book to cover Oracle8 and offer specific guidelines for implementing the physical model--from the best-selling author of Oracle Designer/2000 Handbook. The ultimate guide to designing with Oracle8's Object-Relational Model. The authors show users how to implement the concepts in the real world--teaching how to fully exploit the Object-oriented capabilities of Oracle8. They cover the often neglected areas of database design system req uirements, like changes to records, data entry errors, and basic transaction history.

This book will have the same basic structure as the first edition, with the addition of PL/SQL V3 features. New features sucy as LOs, and ADTs are integrated throughout the book. It will also include common business problems and their solutions using PL/SQL, using real-world examples where applicable. Because PL/SQL is a very popular language with Oracle databases, it is important for DBAs to understand how PL/SQL works and how to tune PL/SQL programs to make them run in the most efficient manne r. This book details all the important features of PL/SQL 3.0 that are essential to Oracle developers, experienced programmers, and Oracle database administrators

Oracle8 Tuning provides the information database system administrators need to customize the Oracle8 database system to the specific needs of its users. Readers will learn strategies and systems to avoid problems, increase database speed, and ensure overall security. They'll also learn the basics of improving Oracle's performance as well as how to use its tools and networking capabilities. The author discusses optimization of DEC, SUN, and other popular platforms.

Oracle8: The Complete Reference is completely updated to cover versions 7.0 through 8. The book is organized in 6 parts. Part I introduces database concepts. Part II discusses SQL, the Structured Query Language which allows programmers to process information to and from a database. Part III is the Hitchhiker's Guide to the Data Dictionary. Part IV discusses database design consideration. Part V is a big, alphabetical reference for virtually every Oracle command. Part VI lists the tables used in the book. The book offers both terrific coverage of using Oracle and a substantial command reference listing the syntax and sample usage for every major command. It also includes a new chapter called "The Hitchhiker's Guide to the Oracle Optimizer." This presents the SQL operations and tuning issues directed towards a beginner user audience. As with its predecessor, this book will include a CD-ROM. This is particularly valuable for readers for two reasons. First, since the book is large, having quick referencing capability on CD will be attractive to end-users. The sizeable reference section is perfect for electronic access. Secondly, the tables in the book will be accessible on the CD, so users will save both time and money.

Data is king in today's Internet economy. It is ESSENTIAL that companies protect and maintain corporate and customer data. Includes information that every Oracle administrator and programmer must know in order to maximize uptime and recover data without compromising mission critical systems. The only book available on this critical topic. Includes actual corporate scenarios and case-studies.

Prepare to pass All Five exams required for OCP DBA Certification. The only OCP DBA exam guide officially authorized by Oracle Corporation, this book/CD-ROM package offers comprehensive coverage of all five required exams: 1Z0-001: SQL and PL/SQL, 1Z0-023: Database Administration, 1Z0-025: Backup/Recovery, 1Z0-024: Tuning, 1Z0-026: Net8 Administration

Oracle 8i is packed with new features, including an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. This comprehensive guide shows you step-by-step how to make the most of this improved functionality - and master the day-to-day tools and challenges of Oracle database administration. From SQL Plus basics and performance-tuning options to recovery tips and WebDB strategies, Oracle 8i DBA Bible is all you need to optimize a database and keep it running smoothly.

A thorough overhaul of the previous edition - widely considered the Oracle DBA "bible" - wth full coverage of all the new Oracle8i features. Covers everything the administrator needs to know to effectively manage a robust, peak-performance Oracle8i database. Explains how to configure Oracle to be accessed through a firewall from a DBA's perspective. "Solutions" sections illustrates - with annotations - how to implement the techniques described in each chapter. Maintain a robust, mission-critical Oracle8i database - the most manageable Web-enabled enterprise database system available. Oracle8i DBA Handbook provides high-end administrative solutions for the day-to-day DBA. Inside, you'll learn to set up a database for maximum efficiency, monitor it, tune it, and maintain its security.

This book delivers comprehensive coverage of exam objectives, presented according to Oracle's certification guide. Because Oracle's exam scoring provides section scores according to exact objectives, this organization of the book allows you to refocus. Each exam objective is covered in a chapter complete with self-assessment opportunities. Four appendices include a listing and description of Oracle's initialization parameters and other elements to be tested on the exam. These appendices provide information useful post-exam in real-work implementation of Oracle Systems.

Oracle 8i Backup and Recovery Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Backup and Recovery exam (1Z0-025). The book's well organized, concise layout provides thorough coverage of test content and objectives like using Oracle export and import utilities, understanding utilities for troubleshooting, describing Oracle recovery catalog creation and maintenance, and configuring an Oracle standby database. In cludes the supportive Exam Cram features of helpful hints and tips, test taking strategies, realistic case studies, and challenging practice questions.

Oracle 8i Performance and Tuning Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Network Administration exam (1Z0-024). The book's well organized, concise layout provides thorough coverage of test content and objectives like describing Oracle Alert and Trace files, tuning the Shared Pool and Buffer Cache.

Advanced performance tuning with Oracle involves unraveling the mysteries of the SQL database's inner workings. Oracle8i Internal Services for Waits, Latches, Locks, and Memory peels back several layers of the Oracle onion to reveal how things really work. While the author claims his quest to get to the bottom of Oracle still continues, this book is a snapshot of his current knowledge of the performance-critical internals. The book's title tells the whole story about its content. It focuses on waits, latches, locks, and memory allocation because they have a dramatic effect on overall performance. Each of these topics is presented separately, with explanations of how each works under the hood and what can be done to optimize it. Although the title offers plenty of architectural explanation, a solid foundation into Oracle 8i release 8.1 (the version addressed by the author) is a prerequisite for understanding this text. The presentation includes few diagrams. Instead, the author makes a special effort to list relevant Oracle parameters and their descriptions in tables, as well as examples of statistics that can be used in optimization. This is a guide for advanced administrators already on a solid footing with Oracle8i and offers plenty of insight into the crucial undocumented aspects of the relational database.

Teaches beginners the essentials of running Oracle8i on a network, and advises IT managers and security administrators on a full complement of industry-compliant features designed to protect against security hazards. The only title yet published explicitly on Oracle8i Networking. Integrates Oracle servers with network services and Internet services, including advanced networking and security options. Covers integration of Oracle into the Distributed Computing Environment (DCE). (Osborne) Explain s how interactions over a network take place. Describes the hardware and software required, and how all the components interface to produce successful communications between computers and databases. Contains step-by-step procedures illustrated by screen shots. Details on Internet protocols and network encryption are included.

SQL/J is the new standard tool emerging from Oracle - in conjunction with IBM and Tandem - for developing Java database applications using less Java code. First to market - we'll provide the ultimate resource for Oracle database developers looking to simplify the process of creating Java applications. Step-by-step details on using SQLJ in the Oracle8i environment, including real-world case studies demonstrating SQLJ's practical applications. Create powerful portable applications with SQLJ. Enabl e Java to go where it's never gone before! Oracle8i SQLJ Programming explains in detail how to implement SQLJ--the new standard for embedding static SQL directly into Java programs. With SQLJ, you'll use less code and get enhanced portability, compile-time checking, and so much more. This authoritative guide shows you how to create cross-platform, distributed, and Web-enabled applications designed specifically for Oracle8i.

Oracle delivers unprecedented ease-of-use, power and performance for e-commerce applications - and Oracle8i is the database for Internet computing. 80% of all Web sites use Oracle as a back-end. Contains time-saving, undocumented methods for developing Internet application using Oracle and Oracle Application Server. Packed with hundreds of real-world examples and insider secrets compiled from TUSC's standing-room-only conference presentations and Oracle user Groups worldwide.

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernels. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment. It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed, such as Oracle8i and Solaris 8. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases. Another characteristic of this book is that I have organized it into two major areas: data warehousing and Online Transaction Processing (OLTP). This edition of the book places more of an emphasis on application tuning since the application has the most control over the overall performance and scalability. It is important that the application be well designed and highly optimized. Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle database administration.

From the official publisher of Oracle Press books comes this complete book/CD-ROM package for deploying and running Oracle8i on the Linux platform. You'll get step-by-step details on installation, customization, administration, and troubleshooting. Plus, the CD-ROM contains the official version of Oracle8i for Linux and Enterprise Manager. You'll get everything you need to get up and running on Oracle8i for Linux. (Osborne) Provides the user with everything needed to get started using Oracle8i o n the Linux platform. Provides a collection of tutorials and step-by-step guidelines that provides the user with key concepts and hands-on experience necessary to install and deploy Oracle8i on Linux.

Oracle 8i - The Database for Internet Computing. The new release of the Oracle database, Oracle8i, provides the industry's most complete and innovative platform for building and deploying Internet and enterprise applications. Oracle technology is already used by many global Internet brands, such as Yahoo!, Excite, and Egghead, and the release of Oracle8i will cement Oracle's position as the leader for e-commerce solutions. New to Oracle Press - the new Starter Kit line of titles will serve as tu rnkey solutions for Oracle database technology. Standard Starter Kit elements will include: Complete coverage of installation, administration, and troubleshooting. Actual, fullyabled Oracle product on CD-ROM. Oracle8i for Windows NT Provides all the features needed to run a business on Windows NT for enterprise-wide deployment. The ideal self-contained book/disk learning tool for Oracle DBAs deploying Oracle8i in the Windows NT platform. Covers ORacle fundamentals, planning and installing Oracle 8i, PL/SWL, objects, backup and recovery, and more.

Covers two of the most popular server-side component models: Enterprise JavaBeans (EJB) and the Common Object Request Broker Architecture (CORBA). Cutting-edge topics--full details on generating Java Server Pages (JSP) with Java Servlets. Expert, authoritative authors, including product manager of JSP at Oracle. Bonus CD-ROM contains ready-to-run scripts and Java applications. A comprehensive reference for developing Java software components for the Oracle 8i database. The CD-ROM contains SQL sc ripts to create Purchase Order and Observation schemas as well as all of the source code from the text. Softcover.

Provides a comprehensive understanding of database development on the Internet. DBAs will benefit from coverage on the Web Development environment usage and the Internet File System (IFS) feature. Describes the scalable, integrated and robust Java Virtual Machine (JVM) which allows DBAs to write, store, and execute Java code. CD-ROM offers scripts and codes from the book.

Save 20% on four books! Prepare for the Oracle Certified Professional exams using this complete Oracle Press study system. In each book, you'll find in-depth details on all the material covered on these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. Books and CD-ROMs combined contain 1,200+ practice exam questions. This boxed set includes: OCP Introduction to Oracle9i: SQL Exam Guide, OCP Oracle9i Database: Fundamentals I Exam Guide, OCP Oracle9i Database: Fundamentals II Exam Guide, OCP Oracle9i Database: Performance Tuning Exam Guide.

Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques.

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.

Explains how to use the Oracle STATSPACK utility to proactively monitor and tune a database by looking at historical trends and performance patterns. The author progressively walks through tuning the Oracle server environment, the global parameters that affect the Oracle database, individual table and indexes within the database, and individual SQL queries. Modified scripts for reading data from the STATSPACK tables and creating reports are provided. Get complete coverage of STATSPACK--Oracle's powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts youll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

In this book, Mr. Price takes you from making simple database connections to using object-relational features and covers such essential topics as Oracle9iAS Containers for J2EE (OC4J), JDeveloper, and performance tuning. Read this book and learn how to leverage the full power of Oracle's implementation of JDBC. From the authentic Oracle Press comes the definitive guide to writing JDBC programs for use with the Oracle8i and Oracle9i databases, including details on Oracle extensions. In addition, JDBC support in the Oracle9i database as well as in Oracle9i Internet Application Server (via the containers for J2EE) is covered.

From the exclusive publisher of Oracle Press books comes this thorough guide to Oracle's Java development tool, JDeveloper -- new for 9i. This book explains the JDeveloper IDE and how to build JSPs, Java applications, business components for Java (BC4J), and more.

A practical developer handbook for creating mobile applications on the Oracle platform, Oracle Mobile is the definitive resource for Web designers, Java programmers, non-Java programmers, consultants, project managers, IT managers, Oracle DBAs, and content managers.

"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.

From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!

A reference for RAC and TAF technology, this book demonstrates how to optimize Oracle clustered server environment for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters database. Described are the secrets for successful design of RAC clusters and the expert internals of shared disk technology, raw devices and RAID with RAC. Exposed is the internal concurrency and PCM locking mechanisms within RAC and the configuration of Transparent Application Failover is explained. Also provided are tips for monitoring and tuning RAC applications as well as tricks for using Oracle9i RAC Cluster Guard.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

From the official publishers of Oracle Press books, here is an essential handbook for developers and administrators working with Oracle Portal. The book explains how to build and deploy portal-driven Web sites using Oracle Portal. Step-by-step walkthroughs and significant code samples demonstrate methods for rapidly creating robust forms, reports, charts,and content management applications. Written by a member of the Oracle Portal Customer Advisory Board (CAB) and a member of the IOUG-A Portal S pecial Interest Group (SIG), this Oracle-authorized resource includes Oracle 9i Application Server 1.0.2.2 on CD-ROM.

This is a very interesting read for any Unix DBA, full of comprehensive explanations and diagrams on the way in which Oracle interacts with the Unix server. There are many detailed Unix Scripts to help you monitor your instances, which can be run via Statspack (dbms_job) and/or via the Unix cron. There is additional information on some more complicated UNIX commands, and copious small tips and tricks that will help in everyday Database Administration tasks. The book also covers commands for all different Unix environments Solaris, HP-UX, Tru64, AIX etc and help you interpret results from vmstat, sar and other Unix admin utilities.

From the official Oracle Press comes a comprehensive guide to developing XML-based e-Commerce applications on the Oracle Internet Platform. Written by the Oracle XML Development Team, this insider's resource explains how to take full advantage of the Oracle XML Developer's Kit (XDKs) and maximize Oracle9i's XML-enabled features. Create and deploy cross-platform, transaction-based applications on Oracle9i with XML--the industry standard for describing data for e-business application integration a nd business-to-business exchanges. Written by members of the Oracle XML Development Team, this insider's resource explains how to take full advantage of the Oracle XML Developer Kit (XDK) to build, manipulate, transform, and view XML documents. You'll also learn from real-world case studies

This authorized guide from Oracle Press explains how to implement the Oracle9i Server on Windows NT/2000. You'll get details on operating system fundamentals, installation, and configuration, plus intermediate and advanced topics such as architecture, migration, clustering, parallel server

From the authorized Oracle Press comes a unique volume, packed with undocumented tips ; techniques from Oracle experts, for maximizing Oracle9i on the Windows 2000 platform. You'll get full coverage of critical high-end features such as clustering and standbys and methods for ensuring high availability. You'll also get full details on all the features new to Oracle9i. Take full advantage of the strength and reliability of Oracle9i and the management features of Windows 2000. Written by the expe rts and authorized by Oracle Corporation, Oracle9i for Windows 2000 Tips & Techniques presents insider best practices for installation, upgrades, migration, tuning, backup and recovery, clustering, and high availability. You'll also get in-depth details on the new features of Oracle9i.

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables. Master all the powerful features of Oracle9i using the exclusive information ins ide this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.

This book is the only administrator's resource for PeopleSoft and covers not only the latest version, 7.5, but earlier ones as well. PeopleSoft installations are notoriously difficult to administer, and this book has everything administrators need to know, whether they are using the Human Resources, Financials, or other modules. Coverage includes setting up the system, security, performance tuning, dealing with upgrades, disaster recovery, troubleshooting advice, and planning for the future. The book also covers the development tools that an administrator must know about, because 90 percent of an administrator's problems are data-related. Bilbrey is a Human Resources IS manager and internal systems consultant for a large insurance company in the southeast.

PeopleSoft has become one of the leading Enterprise Resource Planning (ERP) software companies. The number of companies that use PeopleSoft ERP software keeps increasing. This step-by-step book is the easiest and least expensive way to teach yourself essential PeopleSoft skills to advance your professional career in the fast growing field of ERP programming. The readers will learn PeopleSoft database software by doing the exercises in the book, following the step-by-step procedures illustrated w ith numerous figures of the application windows.

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.

A real-world reference on how an application is developed with PeopleSoft software (PeopleTools), including information on relational entities, data objects, default functionality, and error checking. The book uses detailed, step-by-step examples of an actual application created by the author for a client, and includes a multitude of screen shots and CD-ROM screen cam files that explain exactly how to implement these examples. This book is not module specific. It covers the technical topics that are taught in several weeks of PeopleSoft training.($$$) This book is primarily for people who are new to PeopleSoft and or their primary job is functional. If this describes you and you would like to understand how you can use the PeopleSoft building blocks to create new functionality, this book is for you. Along with the basic PeopleSoft objects, the book includes sections on PeopleCode and SQR.

Perl programmers increasingly rely on the Web, online help, and other online information sources to solve technical problems. Version 2.0 of O'Reilly's Perl CD Bookshelf gives you convenient online access to your favorite books from your CD-ROM drive. This updated version of The Perl CD Bookshelf contains the third edition of Programming Perl; a new book, Perl for System Administration; and a powerhouse of other O'Reilly Animal Guides. You'll have access to the combined resources of complete, un abridged versions of Perl in a Nutshell, Perl Cookbook, and Advanced Perl Programming, along with the new books. As a bonus, we've enclosed the paperback version of Perl in a Nutshell. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The Perl CD Bookshelf, Version 2.0, can be accessed with any web browser. The books are fully searchable and cross-referenced. In addition to individual indexes for each book, there is a master index for the entire libr ary. With the CD Bookshelf, you get a complete Perl library that you can easily carry with you anywhere you need it.

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal. You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities. The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate wi th Oracle databases. Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason. The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tas ks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more.

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal.You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers:The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities.The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate with Or acle databases.Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason.The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tasks: monit oring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more.The book also explains how Oracle DBAs and developers can extend the toolkit and solve their own database administration problems using Perl.

A guide for Oracle DBAs who are too busy to build a clustered server environment to learn about Oracle's Real Application Cluster technology, this book allows DBAs to build and configure a Real Application Cluster quickly and inexpensively. Covers how to find the right hardware to build an at-home RAC, where to get Linux and how to set it up, how to install the Oracle Cluster Manager, and how to create the RAC database.

Physical Database Design Using Oracle correlates logical data models with the physical implementation structures that Oracle provides. It allows students to learn how to take logical data models and convert them into a series of data structures that permit fast and easy logical access to data. This textbook is targeted at undergraduate and graduate IS students studying to become the Oracle professionals of the near future. It is expected that they already have exposure to basic Oracle database a dministration. The expert guidance provided by this textbook provides the insight needed to choose appropriate physical models for mission-critical applications.

Physical Database Design Using Oracle correlates logical data models with the physical implementation structures that Oracle provides. It allows students to learn how to take logical data models and convert them into a series of data structures that permit fast and easy logical access to data. This textbook is targeted at undergraduate and graduate IS students studying to become the Oracle professionals of the near future. It is expected that they already have exposure to basic Oracle database a dministration. The expert guidance provided by this textbook provides the insight needed to choose appropriate physical models for mission-critical applications.

This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command.

PowerBuilder 7.0 Unleashed is an excellent one-volume reference to new features in Sybase's well-known programming tool, with good coverage of its support for distributed and Internet-based computing. Ideal for any intermediate developer, this book compiles a host of useful tips for getting the most out of your PowerBuilder applications, providing a soup-to-nuts tour of PowerBuilder, plus full coverage of its various "painter" tools (such as the Window, Application, and Menu Painters). The new a nd advanced features in the PB environment are explained thoroughly. Short, task-based programming excerpts that show how to carry out specific tasks are the rule here. The discussion of the DataWindow control (traditionally the most powerful feature of PB) is outstanding in this book. Several chapters cover basic and advanced programming techniques and include valuable insights on optimizing the performance of this powerful object. Advanced material looks at ways to extend DataWindows, such as customizing SQL, printing, and managing master-detail relationships effectively. (There's also material here on using the HTML version and plug-in versions of DataWindow for browser-based interfaces.) PowerBuilder's traditional support for databases is in ample evidence here, along with an excellent tour of database design, SQL, and hints for optimizing DB performance.

Bernie came up with the idea as he realized that PowerBuilder's richness presents a great learning challenge. A large part of that learning involves 'inventing' the tricks one needs to solve specific problems. Bernie believed that other PowerBuilder developers were treading a similar path and were 'inventing' their own tricks. He conceived the 'Slick Tricks' column as a means for this community to share these tricks. Over the course of the last fifty months Bernie has been building up a collecti on of these tricks and has found them to be useful in his consulting engagements. Now you can have these slick tricks, originally published in the PBDJ and enjoyed by thousands, in a bound and indexed edition. You will not find a book like this anywhere else.

A lot of books seem to give canned explanations of how oracle works - geared towards rote memorization as opposed to understanding. This book does a great job of taking the next step. For example, The detail with which the author goes through the process of how updating a row actually works in an Oracle database was tremendous. His explanation of how a select statement could actually cause a row to be marked as committed ( i.e. a read causes a write ) was great. I've only been a DBA (or pseudo-D BA) for about 6 months now, so I'm certainly no expert in this area. Yet I found all of his explanations very clear and easy to understand. If you're looking for a new Oracle book, get this one.

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

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.

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.

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.

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.

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.

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.

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.

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.

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 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.

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.

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.

By tapping the strengths of the open-source movement, developers can write custom Linux software without spending a dime on licensing fees. Aimed at the experienced C/C++ programmer, Professional Linux Programming provides a wide-ranging and hands-on guide to the different pieces of the puzzle that are required to program successfully on this exciting new platform. The book is framed as a case study for building a custom database program in Linux for a video rental store. After a tour of the re quirements and a brief look at project management for creating this software, the various Linux packages that are needed to implement this system are described, along with sample code, most of which is written in C. Some packages, such as the CVS version-control package, come with most distributions of Linux; others will require downloading additional software over the Internet. In every case, you're provided with the actual command-line arguments that are needed to install, configure, and run e ach package. Two prominent chapters take you on a tour of the essentials of other programming languages. There's PHP for Web development and an appealing, enthusiastic introduction to Python (which probably will turn you into a Python convert). Later chapters provide practical tips for testing and debugging applications, including how to profile your code. The book closes with a useful guide to creating Red Hat Package Manager (RPM) packages for deploying applications, as well as an overview of your options for internationalization.

Oracle Corporation has broadened its development platform, integrating open standards such as Java and XML into the heart of the Oracle 8i database. This extended programming environment continues to exploit the qualities of scalability, reliability and efficiency of the world's most successful data management software, but at the same time it provides new challenges and opportunities to programmers. This book shows you how to develop enterprise PL/SQL applications exploiting Java and XML, and h ow technologies such as EJBs can be moved to the 8i database. You'll work through case studies using a mix of both familiar and unfamiliar tools and languages, showing you how the various programming approaches can enhance each other.

A good book for an introduction to Oracle, but especially good if you are interested in the areas of Business Intelligence, HTML-DB, XML DB and Regular Expressions

Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business. Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are e asy to manage and modify as the business evolves.

Perl is a powerful programming language that has grown in popularity since it first appeared in 1988. The first edition of this book, Programming Perl, hit the shelves in 1990, and was quickly adopted as the undisputed bible of the language. Since then, Perl has grown with the times, and so has this book. Programming Perl is not just a book about Perl. It is also a unique introduction to the language and its culture, as you might expect only from its authors. Larry Wall is the inventor of Perl, and provides a unique perspective on the evolution of Perl and its future direction. Tom Christiansen was one of the first champions of the language, and lives and breathes the complexities of Perl internals as few other mortals do. Jon Orwant is the editor of The Perl Journal, which has brought together the Perl community as a common forum for new developments in Perl.

Completely revised and improved, the second edition of Programming Python is an excellent compendium of material geared toward the more knowledgeable Python developer. It includes dozens of reusable scripts for common scripting tasks, and is one of the best available sources of information for this popular object-oriented scripting language. In over 1,200 pages of material, this book offers an extremely comprehensive guide to Python development. Though his book is densely packed with informatio n, Mark Lutz is a lively and witty writer whose focus is on getting things done using the natural strengths of the Python language. To that end, after an introduction and history of the language, the book shows how to use Python for performing automated tasks with files and directories (for example, for doing backups both locally and on Web servers). Not only will this book teach you more about Python, but it will also give you a library of code that you can use as is or adapt for your own proje cts.

From access counters and log-report graphs to scientific plots and on-the-fly animated GIFs, graphics scripting is within the grasp of most Web authors. However, it is a poorly documented field. Programming Web Graphics with Perl & GNU Software shows intermediate and advanced Web designers how to use CGI scripts to generate dynamic graphic content and demystifies the manipulation of graphics formats for newcomers to the Web. "Programming Web Graphics with Perl and GNU Software" shows interme diate and advanced Web designers how to use CGI scripts to generate dynamic graphic content and demystifies the manipulation of graphics formats for newcomers to the Web.

"The DBI is a database interface module for Perl. It defines a set of methods, variables and conventions that provide a consistent database interface independent of the actual database being used", explains Bunce, the architect and inventor of DBI. He and Descartes, one of the most active members of the DBI community, explain the architecture of DBI and show how to write DBI-based programs. For the DBI expert, they cover the nuances and peculiarities of each individual database driver. The basic s of databases are well-covered, but some experience programming with Perl is assumed. One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based Web and Intranet applications.

Programming with Oracle Developer is packed with expert advice, detailed explanations, and complete solutions that show you how to produce robust, precise, Internet-ready applications for developers. You'll get step-by-step guidance from prototyping through delivering a high-powered Internet application. After reading this book, the reader willUnderstand the nuts and bolts of building applications, including how to choose an appropriate application development life cycleMaster design and prototy ping issues including the new wizards and GUI design features of Developer forms, reports, and graphicsExtend the reusability and optimize the security of your applicationsDeploy Internet applications and integrate them with other toolsCreate robust, Web-enabled Oracle applications

If Python 2.1 can do it, you can do it too … Packed with crystal-clear explanations, hands-on examples, and a complete language reference, this authoritative guide gives you all the tools you need for rapid application development with Python 2.1. From variables, expressions, and other basics to XML, multimedia, and multithreading, Python pros Dave Brueck and Stephen Tanner show you step by step how to master Python components, put them together, and create full-featured applications - in practi cally no time! Inside, you'll find complete coverage of Python 2.1

For anyone who programs in Python, David M. Beazley's Python Essential Reference, Second Edition will serve as a capable and exceptionally competent guide to current Python syntax and library modules. Concise, yet authoritative, this book sets a high standard as a one-volume reference to this powerful object-oriented programming language. Although the author claims that this title is not really a tutorial, the first 100 pages actually provide an excellent guide to the basics of Python as a lang uage. Geared especially to the experienced programmer seeking to see what's different (and potentially better) about Python, sections on the language itself will let you ramp up on the basic and advanced topics. Short sections with code excerpts that show off essential language features will help you learn or enhance your knowledge of Python quickly. Standout sections here include excellent coverage of object-oriented features, like "special methods" that will let you add custom classes to Pytho n that are just as flexible as built-in classes.

Python Programming on Win32 zeroes in on the strengths of the Python programming language for the Windows platform. If you would like to use Python on Windows with Office 2000, this book is a perfect choice for getting started. While it's not an introduction to Python programming itself, the book does present some basic Python examples. (The authors do provide an impressive list of real-world projects that have used Python successfully, including an application at NASA and a major Web search eng ine.) In lieu of a general language tour, this book centers on practical tips and examples for using Python on Windows, beginning with downloading and installing the free Python package. The most useful examples here present a Python library for general accounting objects. You'll learn how to write COM servers in Python and then how to script them in Visual Basic (used here to build user interfaces) and how to control Word and Excel with OLE Automation in Python. One standout example looks at bu ilding and printing accounting reports in Office 2000 using Python as the script language.

Ideal for any working Python developer, Fredrik Lundh's Python Standard Library provides an excellent tour of some of the most important modules in today's Python 2.0 standard. Mixing sample code and plenty of expert advice, this title will be indispensable for programmers. The book presents sample script code--written by a frequent contributor to Python newsgroups--for almost 200 of the built-in modules in Python 2.0 and shows how to solve common programming problems in Python. Instead of a fu nction-based reference, you get sample scripts for a wide variety of solutions centering on different Python modules. Early sections look at core modules for working with the operating system, math, and strings, among other functions. Material on Python's excellent support for files and directories will help you master the file system. Explanations of various encryption schemes will let you add security to your Python scripts.

Written by a Group Product Manager at Oracle, this Oracle Press guide gets you up and running quickly with your first Oracle Fusion applications. Quick Start Guide to Oracle Fusion Development provides only the essential information you need to build applications in a matter of hours. Rapidly learn the building blocks and functionality you'll use most of the time. The progression of topics closely matches the application building process, taking you through a typical developer scenario from star t to completion.

Written by a Group Product Manager at Oracle, this Oracle Press guide gets you up and running quickly with your first Oracle Fusion applications. Quick Start Guide to Oracle Fusion Development provides only the essential information you need to build applications in a matter of hours. Rapidly learn the building blocks and functionality you'll use most of the time. The progression of topics closely matches the application building process, taking you through a typical developer scenario from star t to completion.

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.

An indispensable ready-reference for users of Red Hat Linux, the world's leading Linux distribution. Helps beginning to intermediate Red hat Linux users get up and running quickly and make the most of the tools that come with the distribution. Softcover. CD-ROM included.

This is the fourth book in Sybex's series of official SAP books. This book's focus is on preparing a new SAP installation for future changes and the transportation of data system-wide. You'll find valuable information on how to use a business blueprint and system architecture to your company's greatest benefit. Written by a staff member at SAP, you'll find detailed information to guide you toward getting the most out of your R/3 system. And you'll find a wealth of information and an interactive demo exam on the CD to help you prepare for the CTC (Certified Technical Consultant) exam.

SAP R/3 Performance Optimization: The Official SAP Guide is an essential foundation for R/3 administrators, technical consultants, ABAP developers, and SAP project leaders. Filled with firsthand knowledge gathered using SAP. EarlyWatch and GoingLive Check remote services, this book teaches you how to fine-tune your R/3 implementation - so your organization reaps the benefits of shorter response times and lower overhead. In concert with the companion CD, this book also helps to prepare you to qua lify as a Certified Technical Consultant (CTC) for R/3 Release 4.0

Get the inside scoop on how to set up a smooth installation directly from SAP authors. Not just a user manual or a description of the architecture, this book studies the complexities of setting up and running an R/3 System from the System Administrator's perspective. Filled with practical instructions and design guidance, you will learn about protocols, permissions, security, extending OSS, system evaluation, archiving, and report distribution. Plus the CD includes a test engine, useful toward b ecoming an SAP Certified Technical Consultant.

Provides vital practical assistance to anyone planning the backup and recovery of a very large database system, describing a combined backup and recovery approach for both Oracle and SAP. Describes new features, functions, and tools available in the latest releases of SAP and Oracle and explains how they impact the backup and recovery strategy. Includes diagnosis and interpretation checklists. The author has 16 years of experience working with Oracle and SAP.

Combining theory with everyday practicality, this de?itive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. Some sections show several screen s hots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some readers from the technical content.

This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. Some sections show several screen s hots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some readers from the technical content.

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making chan ges to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making chan ges to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.

"Structured Query Report Writer may not sound exciting at first, but where else can you find a programming tool ... that works with nearly all known relational databases and operating systems, ... and is easy to learn?" So query a consultant couple who cover SQR's basic and advanced features and command syntax for programs integrated with and alien to PeopleSoft applications (covered in the last five chapters). Includes a sample database, standard computer screen graphics, and a bibliography for further queries. "Presented as a tutorial, SQR in PeopleSoft and Other Applications addresses the fundamental SQR language elements with an judicious eye towards making the most of SQR's capabilities. In addition to over one hundred realistic examples for both the novice and veteran, various approaches are offered and critiqued for each problem. Perhaps the *only* available source for real world PeopleSoft problems!

PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good working knowledge of PL/SQL. Many of the current PL/SQL titles are overkill for those who need to use PL/SQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. Sams Teach Yourself Oracle PL/SQL in 10 Minutes is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling on database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. It uses the format of the author's bestselling Sams Teach Yourself SQL in 10 Minutes =, which has proven to be highly effective and popular.

As open systems continue to replace traditional mainframe systems, system scalability is becoming an increasingly important topic. Although far more flexible than mainframe systems, open systems applications tend to be less reliable and more difficult to scale. There is no cookbook approach to solving this challenge: A thorough understanding of the technologies involved is essential for designing scalable solutions that meet long-term business needs. Scaling Oracle8i(tm) offers valuable insights and techniques for designing reliable and scalable online transaction processing (OLTP) applications using Oracle. This book focuses on providing the in-depth information about Oracle and the underlying hardware required to build systems that scale effectively. You will find coverage of relevant hardware and I/O operation; benchmark and database monitoring systems; Oracle internals, operation, and implementation; and UNIX operating system issues that impact Oracle performance and scalability.

Learn to manage, administer, and troubleshoot Windows 2000 using the Windows Script Host (WSH). This expertly written resource explains how to automate tedious tasks at the command line or from within the Windows GUI. You'll learn to implement the latest versions of VBScript, JScript, ADSI, and WMI and avoid commonly overlooked Windows 2000 pitfalls and scripting errors.

There are a number of books on the market which deal with securing Oracle. Unfortunately, most of these books are like the sorts of survey classes you take as an undergraduate - strong on theory, light on practicality. I decided to make it real, get rid of the fluff and like Linus Torvalds said "Talk is cheap, show me the code!" (He invented the Linux OS). I list the things you should do, the reasons you should do these things, and I also provide you with the code to automate as many of these se curity recommendations as possible.

Protecting information assets is challenging for every enterprise, regardless of size and industry, and it has become an even more complex task for enterprises adopting distributed computing environments. Security, Audit and Control Features OracleDatabase, 3rd Edition, provides a new perspective of security and controls over Oracle. This updated edition includes a background and review of security controls and addresses the risks associated with protecting information in a distributed computin g environment of various platforms, versions, interfaces and tools.

The questions in this guide have been selected using this framework: (1) Questions should reflect understanding of concepts (2) Questions should reflect actual hands-on experience (3) Questions should not be based on memorization of arcane names or syntax (4) Questions should reflect issues seen by the majority of DBAs of that skill level. The intent of the questions is that most DBAs, for a given skill level, can successfully answer most of the interview questions. Naturally, no one person coul d be expected to flawlessly answer all of the senior-level questions. Even the most adept DBAs have some areas of weakness. In order to test the fairness of the questions, I asked numerous DBAs, from different backgrounds and companies, to review the questions.

The ideal audience for this book is the new Oracle DBA or UNIX system administrators who have either inherited DBA responsibilities or who want to gain cross-functional skills. Experienced DBAs will find much of this book too basic, and may complain that it doesn't cover the full range of database administration topics. In my opinion the relatively narrow scope of this book is one of its strengths. Instead of overwhelming the new DBA with hundreds of pages it sticks to the essentials. Another p oint in its favor is that the author doesn't attempt to go into gory details about how things work (information that you can get from other books as your comfort level and self-confidence improve), but remains focused on what you need to do in order to effectively manage and support an Oracle 9i instance.

The first part of Special Edition Using Oracle 11i introduces the Oracle ERP applications and R11i concepts. The reader is then educated on proven techniques for implementing these complex and integrated systems. Configuration and usage of each of the financial, distribution, manufacturing, HRMS, and projects applications are covered, followed by a discussion of working with Oracle Support, consulting firms, and compatible software vendors. The appendixes review the employment market, consulting opportunities, and provide the reader with an implementation checklist. All of R11i's new features are covered in-depth and in practical terms. Not only will readers understand Oracle's new capabilities, they will be able to apply them right away.

This book is designed to be the "one-stop shop" for security engineers who want all their information in one place. Content includes the newest vulnerabilities and exploits, assessment methodologies, host review guides, secure baselines, and case studies to bring it all together. Several security experts offer guidance on both technical and strategic subjects.

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more productive; using Toad, you'll find that program changes that once took hours can now be completed in minutes. Toad allows developers to browse their database tables, procedures, and object types; use cod e templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics. Updated for Toad Versions 8.0 and 8.5, this pocket book is packed with quick-reference material: Toad feature and menu summaries, shortcut keys, suggested changes to Toad defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic Toad components: the SQL Editor, Procedure Editor, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization. Whether you're a new or experienced Toad user, you'll find this quick referenc e an indispensable companion to the product and its online help files.

SAMS Teach Yourself PeopleSoft in 10 Minutes focuses on the end-user by covering general tasks including basic navigation skills, working with master data and running reports. This book covers the general PeopleSoft functions that every end-user of PeopleSoft-based applications must know. You will learn all the essential tasks for running PeopleSoft-based applications smoothly and easily. Using concise 10-minute lessons, you will learn how to log on to PeopleSoft, access the PeopleSoft modules, use basic navigation skills, work with master data, generate reports, read and interpret common error messages, and access extensive online help features.

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

Offers a set of proven data models and data warehouse designs for the core functions shared by most businesses, with detailed models for marketing and sales, human resources, inventory, professional services, billing, accounting, and other organization functions. A CD-ROM is available by mail. Of interest to systems development professionals including data administrators, data modelers, database designers, and data analysts. Proven data models that save companies' time and money developing data architectures, databases and data warehouses. The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, contracts, shipments, invoicing, work efforts, budgeting, and accounting. Readers can apply more than one data model to their own company to meet specific data needs.

This practical, field-tested reference doesn't just explain the characteristics of finished, high-quality data models--it shows readers exactly how to build one. It presents rules and best practices in several notations, including IDEFIX, Martin, Chen, and Finkelstein. The book offers dozens of real-world examples and go beyond basic theory to provide users with practical guidance. Packed with real-world examples, annotated diagrams, and a wealth of rules and best practices. Provides experienced data modelers, architects, and engineers with hands-on guidance. DLC: Database design.

In this groundbreaking work, authors and data warehousing visionaries Ralph Kimball and Richard Merz explore a next-generation Web site architecture that exploits the unique nature of the Web's interactivity to dramatically improve an organization's understanding of its relationship with users. The Data Webhouse Toolkit isn't a how-to manual; it is a high-level look at an ambitious new approach to system design. The foundation of the concept of Webhouses is the "clickstream"--the plethora of inf ormation that can be gleaned if only a system could capture and accurately analyze all of the interaction (or lack thereof) that occurs between Web users and the sites they access. The authors take a careful look at all of the valuable information in the clickstream and point out the complications of compiling this precious information from various gathering sources such as the user's machine, ISP, and Web site. The book argues strongly for the application of data warehousing and dimensional ana lysis to the clickstream to radically improve the strategic knowledge of customer motives and actions. While there are no real-life case studies yet to illustrate the concept, this book is bound to whet the appetites of creative entrepreneurs and system architects.

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books . First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, M ySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books . First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, M ySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

More and more, technology professionals are relying on the Web, online help, and other online information sources to solve their tough problems. Now O'Reilly's Linux Web Server CD Bookshelf gives you the same convenient online access to your favorite O'Reilly books - from your CD-ROM drive. The Linux Web Server CD Bookshelf delivers the information power of six complete O'Reilly Animal Guides covering the best of the open source web platform. We've included unabridged versions of Running Linux, 3rd Edition; Linux in a Nutshell, 3rd Edition; Apache: The Definitive Guide, 2nd Edition; MySQL & mSQL; Programming the Perl DBI; and CGI Programming with Perl, 2nd Edition. As a bonus, you also get the new paperback version of Linux in a Nutshell. This confluence of open source technologies represents the platform of choice for developing and deploying high performance web applications. Apache, MySQL, and Perl/Python/PHP are the tools that make Linux a great applications development platfor m, especially for robust web applications that run on Linux servers. Never has it been easier to find what you need to know about Linux web servers online. Formatted in HTML, The Linux Web Server CD Bookshelf can be accessed with any web browser. The books - all 3276 pages of O'Reilly reference and tutorials - are fully searchable and cross-referenced, so you can search the individual index for each book or the master index for the entire collection. With the CD Bookshelf, you have a complete li brary of technical books that you can easily carry with you anywhere you need it.

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

Computer professionals increasingly rely on the Web, online help, and other online information sources to relieve information pain. Now O'Reilly's Oracle PL/SQL CD Bookshelf allows convenient online access to updates of favorite O'Reilly Oracle books. The Oracle PL/SQL CD Bookshelf contains a powerhouse of Animal books for the Oracle PL/SQL developer--all readable with a web browser on a convenient CD-ROM. A bonus hard-copy book, Oracle PL/SQL Programming: A Guide to Oracle 8i Features, is also included. In addition, the CD-ROM includes the complete text of seven books: Oracle PL/SQL Programming; Advanced PL/SQL Programming; Oracle Web Applications; Oracle Built-in Packages; Oracle PL/SQL Pocket Reference; Oracle Built-ins Pocket Reference; and Oracle PL/SQL Programming: A Guide to Oracle 8i Features. Never has it been easier to learn, or look up, needed information. Formatted in HTML, The Oracle PL/SQL CD Bookshelf can be read by any web browser. The books are fully searchable and cro ss-referenced. In addition to individual indexes for each book, there's a master index for the entire library.

Perl programmers increasingly rely on the Web, online help, and other online information sources to solve information pain. Now O'Reilly's Perl CD Bookshelf gives you convenient online access to your favorite books from your CD-ROM drive. The Perl CD Bookshelf contains a powerhouse of O'Reilly Animal Guides. Included are complete, unabridged versions of Perl in a Nutshell; Programming Perl, 2nd Edition; Perl Cookbook; Advanced Perl Programming; Learning Perl; and Learning Perl on Win32 Systems. As a bonus, the new hard-copy version of Perl in a Nutshell is also included. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The Perl CD Bookshelf can be accessed with any Web browser. The books are fully searchable and cross-referenced. In addition to individual indexes for each book, a master index for the entire library is provided.

Computer professionals increasingly rely on the Web, online help, and other online information sources to solve information pain. Now the second edition of O'Reilly's Unix CD Bookshelf gives you convenient online access to updates of your favorite books on your CD-ROM drive. The UNIX CD Bookshelf contains a powerhouse of UNIX Animal books from O'Reilly plus the complete text and software from UNIX Power Tools -- all readable with your Web browser on a convenient CD-ROM. A bonus hard-copy book, U NIX in a Nutshell, 3rd Edition, is also included. In addition to UNIX Power Tools, you'll find the complete text of the following books: Learning the UNIX Operating System, 4th Edition; Learning the vi Editor, 6th Edition (also new); sed & awk, 2nd Edition; Learning the Korn Shell; and UNIX in a Nutshell, System V Edition. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The UNIX CD Bookshelf can be read by any Web browser. The books are fully s earchable and cross-referenced. In addition to individual indexes for each book, a master index for the entire library is provided.

The book To Become an Oracle DBA in Eighty Days explains the concepts of oracle database using the stories from Jules Verne's novel Around the World in 80 Days: One Oracle Database Architecture Two Oracle Network Configuration 2.1. Client Request 2.2. Network Configuration Files 2.3. Listener Static and Dynamic Register 2.4. Listener Failover and Load Balance Three Database Grid Control 3.1. Grid Control Structure 3.2. Event and Notification 3.3. Scheduled Job Four Backup, Recovery and RMAN 4.1. System Change Number (SCN) 4.2. Online Backup 4.3. Recovery 4.4. Oracle Recovery Manager (RMAN) Five Oracle Real Application Cluster (RAC) 5.1. Physical Structure 5.2. Resource Coordination 5.3. Cache Fusion Six Performance Tuning.

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.

Step-by-step configuration guide for Tru64 UNIX 5.1 TruCluster and Oracle9i RAC. Oracle9i RAC installation and configuration tips. Command summary included in each chapter. This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and step-by-step instructions assist in the complete inst allation of a Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information.

The Unified Modeling Language (UML), the standard graphical notation for modeling business and software application needs, has emerged as an effective modeling tool for database design. When used as a common modeling language for the many facets of system development, the UML can serve as a unifying framework that facilitates the integration of database models with the rest of a system design. This pragmatic guide introduces you to the UML and leads you through the process of UML-based database modeling and design. The book presents the different types of UML diagrams, explaining how they apply to the database world, and shows how data modeling with the UML can be tied into the Rational Unified Process. UML for Database Design is structured around the database design process: business use case modeling, business object modeling, database requirements definition, analysis and preliminary design, and, finally, detailed design and deployment. For each phase of development the book describ es the overall objectives and workflow of that phase, the status of the case study, the relevant UML constructs, and the nuts and bolts of database modeling and design with the UML. Drawing on their extensive industry experience, the authors reveal the trials and tribulations of database development teams, lessons learned, and pointers for success. Topics covered include: The business use case model Activity and sequence diagrams for modeling database functions and tasks Moving from the business to system model Class diagrams and statecharts Mapping classes to tables Transformation of attributes Rational's UML Profile for Database Design Creating tables from classes DDL scripts, component diagrams, and deployment diagrams

The Ultimate Job Reference & Career Guide for Oracle Professionals! Over 150 Certification Questions, Answers, and Explanations Our books are for readers who must absolutely land their next job in Oracle, and who want to improve their existing positions. ORACOOKOOK readers have a need for information they can use right now. Our series of Oracle interview questions books is a direct answer to that need for instant information in the modern workplace. Our books are written by Oracle practition ers and expert authors who have varied vast experiences in the world of information technology. If great careers begin with a good book, the best careers begin with ORACOOKBOOK Over 150 Certification Questions, Answers and Explanations guide you through your learning process. Suitable for developers of any and every level of Oracle expertise, the book is organized around design, performance tuning, and audit and security. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile implementations.

Database vendors like Oracle and Sybase have signed on quickly with Java support. The result has been a growing list of database standards (like SQLJ) that let DBMS products interoperate with Java. Written for the competent programmer, Understanding SQL and Java Together surveys all of today's standards for making database development easier with Java. Many books on Java cover JDBC in detail, but this title goes much further by surveying a handful of other database standards from a variety of v endors, including Oracle and Sybase. (Don't worry: there's full coverage of JDBC for versions 1.0 and 2.0.) The real focus of this book is on SQLJ, which really comprises three standards. SQLJ Part 0 is the easiest to understand, as it supports embedded SQL calls within Java code. Next comes SQLJ Part 1, by which a database product (like Oracle) can use Java to define stored procedures. Here, the authors take care to show off how to deploy JAR files into a database. (Their sample movie database, used throughout this book, is both comprehensible and a little more entertaining than most sample database schemas.)

The Unix for Oracle DBAs Pocket Reference has a remarkably tight focus. It's about making Oracle database management systems run optimally under various Unix operating systems, including HP-UX, Sun Solaris, and IBM AIX (there's also some specialized coverage of IRIX and DEC Unix). Author Donald Burleson assumes readers know how to get around the Unix command shell, and that they're quite familiar with Oracle database administration. To put it simply, to get the most out of this book, you should already know what you want to do, and need only to be told concisely how to do it. This book is ideal for people moving from Oracle administration under Windows to the same job under Unix.

Helps users and information technology professionals interested in implementing Oracle Applications in the workplace. Discusses critical management and implementation considerations for successful users of the Oracle Enterprise Resource Planning Applications, and provides details for the suite of financial, manufacturing, distribution, and HRMS applications. Gives tips on system administration, multi-org and workflow software, and vendors of other compatible software packages, and discusses the Oracle employment and consulting markets.

VB & VBA in a Nutshell: The Languages documents the latest version of the world's bestselling rapid application development environment. Paul Lomax's explanation of the language comes in two main parts. First, Lomax explains the structure and syntax of Visual Basic (VB) and Visual Basic for Applications (VBA) programs. He details all the important stuff, including how to work with variables, how to create custom functions, how to create classes, how to handle errors, and how to react to user events. If you're up to speed on general programming concepts and just want to know how to get something done in VB/VBA, you'll find this part of the book especially handy. The second, and largest, part of the book is a language reference in the classic O'Reilly style. Every function, statement, keyword, and miscellaneous bit of code has a clear, complete entry. Each entry includes a statement of syntax, a description of the function's purpose, a quick example of its use, and some tips for usin g it successfully.

Visual Basic has been described as a visual interface design package to which the programmer attaches snippets of code. Although this definition has been contested by some, no one would contest that Visual Basic's interface design component -- and therefore its forms and controls -- are central to Visual Basic. To create a professional application, the developer needs extensive knowledge of Visual Basic controls, and of their numerous properties, events, and methods. Visual Basic Controls in a N utshell is the book that documents Visual Basic controls thoroughly. This quick-reference guide covers one of the crucial elements of Visual Basic--its controls and their numerous properties, events, and methods. It probes extensively into the forms, modules, and classes of Visual Basic programming features and contains a detailed summary of intrinsic and custom controls with an overview of major characteristics of each.

This is the first complete guide to building Web applications with Oracle Portal 3.0 for Windows NT/2000 and Linux. Oracle Portal specialist Mohamed El-Mallah covers the entire development lifecycle, from product installation through configuration, capacity planning, development, integration, deployment, and administration. Through a start-to-finish case study, El-Mallah introduces every key concept and technique Oracle Web developers and Oracle9i Application Server administrators need to master . Complete lifecycle coverage: planning, development, deployment, and administration. Installation, tuning, and troubleshooting O9iAS/Portal on Windows and Unix. Building Portlets, PL/SQL and Java providers, even advanced PDK programming. Integrating Forms, Reports, interMedia Text, LDAP OiD, Dynamic Services, and supporting SSL in Oracle9iAS Portal. Includes the complete export of the demo application and the source code on CD-ROM. The book demo application is live on the Web.

Windows scripting gives you the power to automate most routine network tasks. This comprehensive guide shows you how to harness today's cutting-edge scripting techniques -- and double, triple, even quadruple your productivity as an administrator. From Windows Scripting Host fundamentals to nuts-and-bolts advice on scripts for user account configuration, data retrieval, system analysis, and more, master scripter William R. Stanek shows you step-by-step how to become a Windows scripting pro.

This concise book takes the reader through the very basics of scripting all the way up to advanced topics such as Active Directory Service Interfaces (ADSI) and Windows Managment Instrumentation (WMI). Teaches the Windows administrator to quickly write complex scripts without requiring any expertise in programming. Explains commands and keywords, using Shell Scripting, KiXtart, and Windows Script Host (WSH) as the example scripting tools, while providing examples to illustrate functions. Illustr ates how to use scripting to perform user and group management, backups and scheduling, and make key security and registry changes for today's most popular programs(such as MSIE, Office, and anti-virus programs).

The new Windows Scripting Host finally offers system and networks administrators a powerful means to automate many of their most common tasks. In this concise professional reference, expert author William Stanek introduces readers to this new feature and shows them how to put it to work with the VBScript or JScript scripting languages. In addition, Stanek thoroughly explains how to use the older Windows NT shell command language to automate tasks not yet possible with WSH. Parts 1 and 2 of the b ook introduce the reader to traditional batch scripting and the new Windows Scripting Host, a feature now found on Windows 98, Windows NT 4 Workstation and Windows NT Server 4. The book also introduces the reader to the two most-widely-used scripting languages on Windows platforms, VBScript and JScript, and shows how other popular languages, such as Perl, could be substituted. The remaining parts of the book show how to create scripts of increasing sophistication to solve common administrative p roblems on Windows 98 and Windows NT 4 Workstation clients, Windows NT 4 servers and networks of NT hosts.

The command line isn't dead--far from it. Administrators of big Windows NT networks know that the best way to accomplish a difficult task frequently involves using the console interface rather than the graphical user interface. By writing batch routines, it's relatively easy to perform fancy tasks on local computers and distant ones. In Windows NT Shell Scripting, Tim Hill has done a service by explaining how to write and use scripts under Windows NT. He begins at the beginning, explaining what scripting is and how command lines come to exist under Windows NT. The reader gets full information on virtual DOS machines and how programs started by scripts are instantiated. There's also some useful information on redirecting script output--handy when using batch files to create HTML documents, for example.

Microsoft Windows scripting support has taken off recently, and Thomas Eck has done a lot of useful work at the cutting edge of this technology. In Windows NT/2000 ADSI Scripting for System Administration, he documents the Active Directory Service Interfaces (ADSI) as they apply to systems administrators interested in using Component Object Model (COM) objects written in Visual Basic to automate administrative tasks. Because this book is backed by such a considerable development effort, administ rators of large Windows NT and Windows 2000 networks will be able to put its ADSI solutions to profitable use immediately. Though he does provide a conceptual introduction to ADSI and the services implemented in Active Directory, Eck's book is all about code. Code listings appear in quantity. It's one recipe after another, collectively covering hundreds of administration tasks, with minimal commentary on each solution. After all, this is a book for system administrators, and the idea is that the y're not so much reading to become programmers as to see the assortment of tools they can use to solve problems.

Windows scripting can automate almost any system task, enhance system and software functionality, and streamline network administration -- if you know what you're doing. Offering the most comprehensive Windows scripting coverage anywhere plus hundreds of ready-to-run scripting solutions on CD-ROM, this unique guide reveals the little-known scripting secrets that will take your productivity to a new level.

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

2001-2011 Oracle-Books.com