Free Oracle, MySQL, MsSQL, Access, DB2, SQL, PLSQL, Ebook & Reviews: Oracle

Showing posts with label Oracle. Show all posts

Showing posts with label Oracle. Show all posts

Oracle 10g, 11g, PL/SQL, SQL Server 2005, MySQL Ebooks

You can find book reviews regarding Oracle 10g, 11g, PL/SQL, SQL Server 2005 and MySQL. These books teaches you to install, create and share SQL Server 2005 reports, SQL server rendering, SQL Server reporting, Deploy and maintain report models, SQL Server report servicing, data accessing methods of MySQL, MySQL data retrieving and Data storing, Data accessing methods from multiple tables and MySQL statements, copy tables between different servers and MySQL database creation according to time schedules, Oracle Administration, Oracle practical examples, Oracle security implementations, oracle advance security, PL/SQL coding styles & conventions, PL/SQL program construction and package construction, Oracle 11g new features, Oracle resiliency, Data gaurd, RMAN, secure files using encryption, Practical Questions and Lab Questions for OCP, Oracle 10g Database Administrators, drill exams for OCP, and 300 OCP exam questions with detailed answers and explanation.

Following are the Database book reviews.

Related DBMS Ebooks

60 Oracle, PL/SQL, SQL, MySQL, Sybase, Microsoft SQL Server, ebooks

Download free DBMS Ebooks

This posting helps you to get free ebooks and tutorials on Datawarehousing, Data Mining, DBMS, RDBMS, ORACLE, PL/SQL, MySQL, Microsoft SQL Server, Microsoft ACCESS, Data modelling techniques, Database programming with several languages, DB2, information modelling, information retrieval, Oracle datawarehousing, sqlplus , etc

Visit the following links to get free ebooks downloads in oracle, pl/sql, mysql, sql server, access , etc. Ebooks provided by this site are

Oracle PL/SQL Built-ins Pocket Reference

By Steven Feuerstein, John Beresniewicz and Chip Dawes

The Oracle PL/SQL Built-ins Pocket Reference is a quick reference guide to the many built-in packages and functions provided by Oracle Corporation. It contains a concise description of the syntax for the following:

Built-in packages
Built-in functions
RESTRICT REFERENCES pragmas for the built-in packages
Nonprogram elements (e.g., constants, exceptions, etc.) defined in the built-in packages

Although we don't include every single package and function in this pocket reference, we've included all the built-ins that most PL/SQL developers will ever need to use.

The purpose of this pocket reference is to help PL/SQL users find the syntax of specific built-in headers. It is not a self-contained user guide; basic knowledge of PL/SQL and its built-ins is required. For more information, see the following books:

Oracle PL/SQL Programming, by Steven Feuerstein and Bill Pribyl (O'Reilly & Associates, Second Edition, 1997).
Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly & Associates, 1998).

Click to Read More

Oracle PL/SQL Language Pocket Reference

By Steven Feuerstein, Bill Pribyl and Chip Dawes

The Oracle PL/SQL Language Pocket Reference is a quick reference guide to the PL/SQL programming language, which provides procedural extensions to the SQL relational database language and a range of Oracle development tools.

Where a package, program, or function is supported only for a particular version of Oracle (e.g., Oracle8i), we indicate this in the text.

The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required.

For more information, see the following books:

Oracle PL/SQL Programming, 2nd Edition, by Steven Feuerstein with Bill Pribyl (O'Reilly & Associates, 1997).
Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly & Associates, 1998).
Oracle PL/SQL Built-ins Pocket Reference, by Steven Feuerstein, John Beresniewicz, and Chip Dawes (O'Reilly & Associates, 1998).

Click to Read More

Oracle Web Applications PL/SQL Developer's Introduction

By Andrew Odewahn

The goal of Oracle Web Applications is to help Oracle SQL and PL/SQL developers who have little or no web programming experience to learn to develop useful web applications, using technologies most IS developers can grasp fairly quickly: WebDB, Oracle Application Server (OAS), PL/SQL, HTML, and XML.

In addition, the book introduces several other Oracle8i technologies -- Advanced Queuing (AQ), the Internet File System (iFS), interMedia, InternetLite, and Java(TM) -- and shows how they form a cohesive development framework that addresses the pressing issues of web content management, application development, and application integration. While there have been many changes in Oracle8i, it's still just a database, and there's no need to panic: data is data, whether it comes from the accounts payable system or from the Internet.

This book acknowledges that you're a busy person. Since most of us simply don't have time to read and digest an 800-page book on each individual technology, I've tried to present fundamental elements of the topics you'll use most often in your daily development efforts. This book will get you started and solidly on your way, but it's not, obviously, the ultimate reference. Rather, it is a "Cliff Notes" of Oracle web development -- enough to help you pass the test, but not enough to help you appreciate the finer points. Once you've read the book, however, you'll be ready to delve into the various areas (WebDB, PL/SQL, Java, etc.) more deeply. Your first step on that journey should be to consult the appendix for information on further resources.

Click to Read More

Advanced Oracle PL/SQL Programming with Packages

By Steven Feuerstein

Who would have thought that just one year after the publication of Oracle PL/SQL Programming, a 916-page tome on "everything PL/SQL", I'd end up writing a second book about the PL/SQL language? Although back in September 1995 I wasn't arrogant enough to think that I knew all there was to know about PL/SQL, I also underestimated how much more I had still to learn!

I am firmly of the belief that one never stops learning -- as long as one is open to learning. The area of PL/SQL in which I needed lots more education turned out to be packages. In my first book I explained how to build and use packages. I even provided lots of examples of package construction. But I started to realize that this wasn't enough. Over the past year, I have been designing and developing a set of packages to help me build PL/SQL-based applications. This was a thoroughly selfish effort: I wanted to be as productive as possible, and I wanted to overcome a number of weaknesses -- however transient -- in the PL/SQL language. In the process of writing this software, I learned a good deal about the best ways to build PL/SQL code, especially regarding packages. I also discovered some very interesting techniques that can make packaged software more maintainable, accessible, and easy to use.

As my thinking on the construction of packages crystallized, I began to view all of my packages as a library of code that could be used by any PL/SQL developer. I also realized that I wanted to share the new techniques and lessons I had uncovered. The result? This book and the PL/Vision product.

How often do you find yourself writing a program and simultaneously thinking: somebody must have done this before! You feel certain that you are reinventing the wheel. Worse, if you are sufficiently honest with yourself, you will also admit that someone else has probably spent more time on the problem and has already come up with a better solution than you are likely to develop for your specific application.

Often, you know you should take the time to "genericize" a program so that you can use it again and again in different circumstances. Somehow, however, you never find the time -- and the mental space -- to take your code to that higher level of abstraction.

So you limp along, accepting a relatively low level of productivity and reusing a truly minimal amount of code. You write the same things over and over and simply push aside the feeling that you are wasting your time.

Oracle developers are fortunate to be able to use an advanced, robust language like PL/SQL. PL/SQL developers are, on the other hand, less than fortunate (at least as of September 1996) to find that the supporting environment for PL/SQL is still very immature. Where are the debuggers, the code formatters and generators, the toolboxes of reusable programs and objects? When will we have a powerful editor that knows about PL/SQL syntax and -- more importantly -- the stored code available for execution?

When, you might also ask, will this guy stop complaining? It is acceptable to identify weaknesses. It is constructive to analyze areas for improvement. At some point, however, you have to stop whining and start improving things for yourself. Best yet, keep on whining but engage in self-improvement at the same time!

This book will help you write better packages. It will also show you how to use the "prebuilt" packages of the PL/Vision software product -- my attempt to change the "situation on the ground" for PL/SQL programmers. Finally, I hope that it will, via examination of my source code and the way I separated functional areas in PL/Vision, offer a blueprint for PL/SQL developers to discover how to take full advantage of PL/SQL packages in their day-to-day programming.

Click to Read More

Oracle Built-in Packages

By Steven Feuerstein, Charles Dye and John Beresniewicz

After publishing more than 1,600 pages on Oracle PL /SQL in two previous books, I marvel at the existence now of this third book covering yet other aspects of the PL /SQL language. I can still remember quite distinctly a moment in September, 1994, when I embarked on writing the first draft of Oracle PL /SQL Programming and wondered: are there really 400 pages worth of material on that much-used and often-maligned procedural language from a nonprocedural (SQL) company? If the answer to that question was a resounding "yes" in 1994, then the answer is a deafening roar today!

Maybe PL /SQL isn't the answer to every object-oriented programmer's deepest desires. Maybe developers are badly in need of -- and unreservedly deserve -- better tools with which to write, debug, and reuse PL /SQL programs. Maybe PL /SQL isn't perfect, but the reality is that hundreds of thousands of people around the world work (and struggle) with PL /SQL on a daily basis. We all need as much information as possible about how we can make the best possible use of Oracle PL /SQL.

And that is the objective of Oracle Built-in Packages. If you are going to build complex applications using PL /SQL, you will not succeed unless you learn about and figure out how to utilize many of the packages described in this book. Packages are the method of choice for Oracle and third parties like RevealNet, Inc., to extend the base PL /SQL language, to improve ease of use, and to provide brand-new functionality in the language. Writing PL /SQL code without knowing about or using built-in packages is akin to building an automobile and ignoring the last 20 years of technological advances. The resulting machine will run more slowly, use more gas, and be harder to repair.

Oracle Built-in Packages grew out of Chapter 15 of the first edition of Oracle PL /SQL Programming. When Oracle released Oracle8, it was time to update that book to include the wide-ranging new PL /SQL8 functionality. It was clear from the start that this second edition, if organized like the first, would have been well over 1,500 pages in length -- a totally impractical size for a developer's handbook.

What to do? Based on feedback from developers about Oracle PL /SQL Programming, there was an enormous amount of interest in, and often confusion surrounding, the built-in packages. These Oracle-provided "add-ons" to PL /SQL clearly needed more detailed coverage, more examples, more tips, more of just about everything. My single chapter of 100 pages was woefully inadequate. We made the decision to move that single chapter out of Oracle PL /SQL Programming and expand it into a book all its own. You are holding the result.

I recognized early in the process that I couldn't personally cover all of the Oracle built-in packages discussed in this book. I didn't have the necessary expertise, nor the time to learn, nor the time to write it all. So I sought and received the help of two excellent Oracle technologists: John Beresniewicz and Charles Dye.

Over the past six months, John, Charles, and I have researched the packages provided by Oracle in the database, verified the documentation, uncovered aberrant behavior, and discovered neat tricks. We also made it a priority to construct package-based utilities that you will be able to put to immediate use.

While Oracle Built-in Packages is a collaborative effort, it is also a combination of very individual efforts. As such, you will find differences in coding styles and philosophies. Rather than try to enforce a single standard throughout, I welcomed the variations (as long as all contributed in their own way to a deeper, clearer understanding of the PL /SQL technology). There is rarely a single right way to do anything, and there is an enormous amount we can learn from the different journeys each of us takes to a solution.

Click to Read More

Oracle PL/SQL Programming - Guide to Oracle8i Features

By Steven Feuerstein

2700 pages and still writing! Sometimes I feel like the Energizer Bunny of PL/SQL. But Oracle keeps the features coming, and after all these years, I'm still enthusiastic about what PL/SQL can do to improve the quality of life for developers. Even with the coming of Java(TM) in Oracle8i, I believe strongly that the future is bright for PL/SQL developers.

This short book is something of a departure for me -- those of you who have read my larger tomes may wonder if I've found a ghostwriter! Now that Oracle8i is here, it's my intention to update Oracle PL/SQL Programming (now in its second edition) to cover the new version of the Oracle database. Along with developing a third edition of that book (with my coauthor Bill Pribyl), I'm taking a critical look at all of my books to make sure that the O'Reilly & Associates PL/SQL series offers a comprehensive resource for PL/SQL developers.

For now, though, PL/SQL developers need current and useful information about the latest PL/SQL features; there are a lot of them, and some represent major changes in the language. This small book is intended to get you started on understanding these features and using them to best advantage.

For many people, the big news about Oracle8i is Java, and the big question for many PL/SQL developers is how (and whether) to use Java in conjunction with PL/SQL. Chapter 9, Calling Java from PL/SQL, is a roadmap showing PL/SQL developers how to employ Java right now. It doesn't attempt to teach you the basics of Java -- there are many other books that serve that purpose -- but it does teach you how to access Java from within PL/SQL.

Click to Read More

Oracle PL/SQL Programming Second Edition

By Steven Feuerstein and Bill Pribyl

What, specifically, will this book help you do?
Take full advantage of PL/SQL. The reference manuals may describe all the features of the PL/SQL language, but they don't tell you how to apply the technology. In fact, in some cases, you'll be lucky to even understand how to use a given feature after you've made your way through the railroad diagrams. Books and training courses tend to cover the same standard topics in the same limited way. In this book, we'll venture beyond to the edges of the language, to the nonstandard ways in which a particular feature can be tweaked to achieve a desired result.

Use PL/SQL to solve your problems. You don't spend your days and nights writing PL/SQL modules so that you can rise to a higher plane of existence. You use PL/SQL to solve problems for your company or your customers. In this book, I try hard to help you tackle real-world problems, the kinds of issues developers face on a daily basis (at least those problems that can be solved with mere software). To do this, I've packed the book with examples -- not just small code fragments, but complete application components you can apply immediately to your own situations. There is a good deal of code in the book itself, and much more on the disk that accompanies the book. In this book I guide you through the analytical process used to come up with a solution. In this way I hope you'll see, in the most concrete terms, how to apply PL/SQL features and undocumented applications of those features to a particular situation.

Write efficient, maintainable code. PL/SQL and the rest of the Oracle products offer the potential for incredible development productivity. If you aren't careful, however, this rapid development capability will simply let you dig yourself into a deeper, darker hole than you've ever found yourself in before. I would consider this book a failure if it only ended up helping programmers write more code in less time than ever before. I want to help you develop the skills and techniques that give you the time to build modules which readily adapt to change and are easily understood and maintained. I want to teach you to use comprehensive strategies and code architectures which allow you to apply PL/SQL in powerful, general ways to many of the problems you will face.

Click to Read More

Oracle Data Warehousing Unleashed

By Bonnie O'neill et al

You have decided to embark on a data warehouse journey. You are probably a little scared and overwhelmed by the immensity of the project in front of you. You are probably also wondering where to start.

This book is designed to be a definitive reference guide for all project staff having anything to do with the data warehouse. Here is an overview of the types of job classes that would benefit from this book:

Project managers: The book provides a chapter on project management, and one of the appendixes has a task checklist to assist you. The methodology and architecture chapters help you in understanding what you are going to build and some best-practice guidelines in how to do it. In addition, the rest of the book, while geared for a more technical audience, can give you a feel for what to expect and what kinds of obstacles you will likely encounter throughout the expedition.

Data administrators: A few chapters are designed especially for you: "Data Integration: The Challenges," "Defining Your Data," "Metadata," and the database design chapters. You might also find the architecture and methodology chapters interesting.
Quality analysts: the data integration, metadata, and data scrubbing chapters are right up your alley.

DBAs: Many chapters are of interest to DBAs, including (but not limited to) storage concerns, physical database design, exploiting parallel technology, indexes, kernel performance tuning, and security.

Application architects and developers: There are lots of chapters that help you get a feel for how to exploit the warehouse so the end user can get the maximum benefit possible. Some of these chapters are "Using the Intranet," "Front-End Tools," "Tuning Queries," and "Data Mining."

Data warehouse architects: The book contains a wealth of architecture and methodology information, and also discusses related constructs tangential to the data warehouse, including the operational data store and data marts.

Click to Read More

ORACLE Documentation (Absolute Unique Library)

This page contains links to the most current documentation for Oracle Database, Application Server, Developer Suite, Collaboration Suite and Applications/E-Business Suite.

Database

Oracle Database 10g Release 2
Oracle Gateways 10g Release 2
Oracle Database Lite 10g Release 2
Oracle Content Database 10g Release 1
Oracle Database 10g Release 1
Oracle Gateways 10g Release 1
Oracle9i Database Release 2
Oracle9i Database Release 1
Oracle Gateways for Oracle9i (Rel. 1&2)
Oracle interMedia
Oracle Spatial
Oracle Fail Safe
Oracle TimesTen In-Memory Database
Oracle Berkeley DB
Oracle Berkeley DB Java Edition
Oracle Berkeley DB XML
Oracle 10g R2 Lite
Oracle 9i Lite
Oracle Secure Backup
Oracle Application Express

Enterprise Management

Oracle Enterprise Manager 10g Release 3 (10.2)
Oracle Enterprise Manager 10g Release 1 (10.1)
Oracle Enterprise Manager Release 2.(9.2)
Oracle Enterprise Manager (Rel. 9.0.2 & 9.0.1)

Secure Enterprise Search

Oracle Secure Enterprise Search 10g

Tape Backup

Oracle Secure Backup

Technologies / Utilities

BLAF
Oracle Configuration Manager
Oracle Help Technologies
Oracle JSP Engine
Oracle Migration Tools
Oracle ODBC Drivers

Applications

E-Business Suite

Applications Releases 11i and 12

PeopleSoft Enterprise
PeopleSoft Enterprise
Archive PeopleSoft Enterprise

JD Edwards EnterpriseOne
JD Edwards EnterpriseOne
Archive JD Edwards EnterpriseOne

Oracle Retail
Oracle Retail

Siebel Applications
Siebel Applications
Siebel Integrations

Other Applications
Oracle Transportation Management (OTM) 5.5
Oracle Transportation Management (G-Log GC3) 5.0
Pharmeceutical
Oracle Demantra
Oracle Workforce Scheduling

Middleware

Application Server

Oracle Identity Management 10g (10.1.4)
Oracle Application Server 10g Release 3 (10.1.3.2)
Oracle Application Server 10g Release 3 (10.1.3.1)
Oracle Application Server 10g Release 3 (10.1.3)
Oracle Application Server 10g Release 2 (10.1.2.0.2)
Oracle Application Server 10g Release 2 (10.1.2)
Oracle Content Management SDK, 10g (9.0.4.2)
Oracle Application Server Release 10g (9.0.4)
Oracle Content Management SDK, 10g (9.0.4)
Oracle Forms 10g (10.1.2 and 9.0.4) and Oracle9i Forms (9.0.2)
Oracle9i Application Server Release 2
Oracle Content Management SDK
Oracle9i Application Server Release 1
Oracle Internet File System
Oracle Identity Manager
Internet Application Server 8i

Oracle Collaboration Suite

Oracle Collaboration Suite 10g Release 1
Oracle Collaboration Suite Release 2
Oracle Collaboration Suite Release 1

Development Tools

Oracle Developer Suite Release 10g Release 2
Oracle Developer Suite Release 10g
Oracle9i Developer Suite Release 2
Oracle9i JDeveloper
Oracle9i Developer Suite Release 1
Oracle9i Internet Developer Suite Release 1.0.2.4.1
Internet Developer Suite Release 1.0.1
Internet Developer Suite Release 1.0
Oracle Designer
Oracle SCM (Repository)
Oracle Reports
Oracle Forms

Data Warehousing and Business Intelligence

Oracle Business Intelligence
Oracle Business Intelligence Standard Edition
Oracle Business Intelligence Enterprise Edition
Oracle Business Intelligence Applications
Oracle BI Beans
Oracle Data Mining
Oracle OLAP
Oracle Warehouse Builder
Oracle Discoverer
Oracle Express Analyzer/Objects
Oracle Express Server
Oracle Express Web Agent
Oracle Data Mart Suite
Oracle Financial Analyzer
Oracle Reports

On Demand
Oracle E-Business Suite On Demand
Oracle Technology On Demand

Previously Released Oracle Documentation

Database

Oracle8i Database
Oracle8i Database Release 8.1.7
Oracle8i Database Release 8.1.6
Oracle8i Database Release 8.1.5
Oracle8 Database
Oracle8 Database Release 8.0.6
Oracle8 Database Release 8.0.5
Oracle8 Database Release 8.0.4
Oracle7 Release 7.3.4
Oracle Enterprise Manager and Management Packs
Release 2.x
Release 1.x
Oracle Gateways
Oracle Rdb

Data Warehousing and Business Intelligence

Oracle Reports
Oracle Darwin

Application Server

Oracle Application Server
Oracle Forms Services
Oracle Forms 6i
Oracle Forms Archive
Oracle Portal
Oracle9iAS Portal Center
Oracle9iAS Clickstream Intelligence
Oracle9iAS Personalization
Oracle Internet File System
Oracle Unified Messaging
Oracle Internet Directory
Oracle eMail Server
Oracle8i and 9iAS Appliance

Oracle Database 10g Release 1 (10.1) Documentation Library

Welcome to the Oracle Database 10g Documentation Library. Here you can research new information, look up reference information, and search across the entire library.

Getting Started

These books provide background information for new users:
2 Day DBA HTML PDF
Concepts HTML PDF
Administrator's Guide HTML PDF
Master Glossary HTML

Most Popular
These books contain the most commonly used information for general database administration and application development:
2 Day DBA HTML PDF

Concepts HTML PDF
Administrator's Guide HTML PDF
Application Developer's Guide - Fundamentals HTML PDF
Reference HTML PDF
Performance Tuning Guide HTML PDF
PL/SQL User's Guide and Reference HTML PDF
SQL Reference HTML PDF

Upgrade Information

If you are familiar with earlier Oracle releases and are moving to Oracle Database 10g, these books describe the new features, and explain how to upgrade your database.
New Features Guide HTML PDF
Upgrade Guide HTML PDF

License Information

This book explains how certain database features are licensed:
Licensing Information HTML PDF

Companion CD Installation Guides
The Companion CD Installation Guides cover the software other than the main database server. This software works in conjunction with the database, and requires a separate, optional installation. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.

Companion CD Installation Guide for 64-Bit WindowsHTML PDF
Companion CD Installation Guide for Linux x86-64 HTML PDF
Companion CD Installation Guide for UNIX Systems HTML PDF
Companion CD Installation Guide for Windows HTML PDF
Companion CD Quick Installation Guide for 64-Bit Windows HTML PDF
Companion CD Quick Installation Guide for AIX-Based Systems HTML PDF
Companion CD Quick Installation Guide for HP Tru64 UNIX HTML PDF
Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Companion CD Quick Installation Guide for Linux x86 HTML PDF
Companion CD Quick Installation Guide for Linux x86-64 HTML PDF
Companion CD Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Companion CD Quick Installation Guide for Windows HTML PDF

Quick Installation Guides

The Quick Installation Guides cover the basics of installing on a clean machine, using a specific operating system.

Quick Installation Guide for 64-Bit Windows HTML PDF
Quick Installation Guide for AIX-Based Systems HTML PDF
Quick Installation Guide for HP Tru64 UNIX HTML PDF
Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Quick Installation Guide for Linux x86 HTML PDF
Quick Installation Guide for Linux x86-64 HTML PDF
Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Quick Installation Guide for Windows HTML PDF
Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows HTML PDF

Installation Guides
The full Installation Guides cover a wide variety of installation scenarios. Use them if your situation is not covered in the Quick Installation Guides.

Enterprise Manager Grid Control Installation and Basic Configuration HTML PDF
Installation Guide for 64-Bit Windows HTML PDF
Installation Guide for Linux x86-64 HTML PDF
Installation Guide for UNIX Systems HTML PDF
Installation Guide for Windows HTML PDF
Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows HTML PDF
Real Application Clusters Installation and Configuration for All Platforms HTML PDF
Real Application Clusters Installation and Configuration for Linux x86-64 HTML PDF
Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows HTML PDF
Universal Installer Concepts Guide HTML PDF

Client Installation Guides
The Client Installation Guides cover the simplified install for just the Oracle client software, which lets you connect to a database running on a different system, using a database application or the interactive SQL*Plus tool. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.

Client Installation Guide for 64-Bit Windows HTML PDF
Client Installation Guide for Linux x86-64 HTML PDF
Client Installation Guide for UNIX Systems HTML PDF
Client Installation Guide for Windows HTML PDF
Client Quick Installation Guide for 64-Bit Windows HTML PDF
Client Quick Installation Guide for AIX-Based Systems HTML PDF
Client Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Client Quick Installation Guide for Linux x86 HTML PDF
Client Quick Installation Guide for Linux x86-64 HTML PDF
Client Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Client Quick Installation Guide for Windows HTML PDF
Client Quick Installation Guide HP Tru64 UNIX HTML PDF

Teach Yourself Oracle 8 In 21 Days

By Edward Whalen

Contributing Author: Steve Adrien DeLuca

I have worked with Oracle for many years. Every time a new version is released or a new problem crops up, I am rejuvenated; I become excited about working with Oracle again. I want to share this enthusiasm with you, and I hope that after you become familiar with Oracle, more and more aspects of the Oracle RDBMS will interest you. The most important thing is that you enjoy what you are doing; I hope that you enjoy working with Oracle as much as I do.

The Oracle RDBMS is an enormous environment with unlimited potential. When you start working with Oracle, you might find it overwhelming. Don't give up; you will see how the different components work together as you learn about the Oracle RDBMS. Rarely do I undertake a project without learning something new about Oracle.

This book is designed for inexperienced Oracle users. Experienced Oracle DBAs will likely find this book too elementary. Most of the lessons are designed to step the reader through specific administrative and user tasks.

The best way to use this book is to read each lesson, then practice the techniques and tasks outlined in that lesson. Each lesson covers a single topic, so some lessons might be longer than others. If you complete one lesson per day, you can easily complete the full course in three weeks.

At the end of each lesson, you'll find a series of questions and answers. These questions are designed to point out some of the key concepts that were covered in the lesson. Following the Q&A section, you'll find a series of quiz questions that focus on techniques and tasks covered in the lesson. Each lesson also includes a series of exercises that are intended to familiarize you with some of the key tasks covered in that lesson.

Click to Read More

Oracle™ Unleashed

First Edition

Sams Publishing

Introduction

When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. If you were an experienced Oracle developer three years ago and since then have been locked away—not able to see the new Oracle versions of the database and tools—there will be very little that you will recognize today. Along with changes in other computing technologies, the rate of change with Oracle is constantly increasing, which is all the more interesting for us who get turned on by the software. You'll get a running start with the pages that follow.

Oracle Unleashed is one of the most comprehensive books on Oracle and its tools available today. It's written by authors who have real-life experience using the Oracle tools (most of whom are members of the Oracle Business Alliance Program). We will show you what's important, the pitfalls, tips from real-life experiences, and code examples—The kind of information that can give you the cumulative experience of many years of expertise.

Click to Read More

Using Oracle 8

Macmillan Computer Publishing

Introduction
Welcome to Using Oracle8! This book identifies the many functions an Oracle DBA needs to perform on an Oracle8 database and explains how to do them as efficiently and effectively as possible. You learn about the key functions of database administration, including installing the product, designing and creating a database and its tablespaces, designing and creating the tables and other objects that make up an Oracle database, designing and executing a good backup strategy with a recovery methodology, and monitoring and tuning performance. You also learn about creating and maintaining users and performing an upgrade to Oracle8, as well as other tasks that you may need in your position as DBA. You also learn when and how to use the various tools Oracle8 provides to assist you in database management, performance monitoring and tuning, data loading, backup and recovery, and data export and import.

The book is designed to let you read about a topic at length when you have the time and the inclination, or to use as a quick reference guide when you need an answer to a pressing technical question or an example to follow when performing a specific task.

Using Oracle8 contains cross-references to related topics so that you can look at all aspects of a topic, even if they're covered in different chapters. These cross-references also enable you to read the book in any order you choose. If you run across a subject you don't fully understand, you can easily switch your attention to the area(s) identified and carry on your reading there. Where applicable, the book also references the Oracle documentation materials, so you can find even more detail if you need it.

Don't forget to keep this book handy at work, just in case you need to check something in a hurry that you haven't read about yet or is a new topic to you. Be sure also to use the tear-out card inside the book's cover. It contains some of the most common, but difficult to remember, information you'll need.

Click to Read More

Developing Client/Server Applications with Oracle

by Paul Hipsley

Sams, Macmillan Computer Publishing

Oracle Developer/2000 is the next generation of development tools for Microsoft Windows applications development from Oracle Corporation. Oracle Developer/2000 leverages the power of Oracle7 and Microsoft Windows. Oracle7 is the most popular Relational Database Management System (RDBMS) in the world and Microsoft Windows is the most popular Graphical User Interface (GUI) in the world. The previous release of Oracle Developer/2000 was know as the Oracle Cooperative Development Environment (CDE). At times you may see or hear references to CDE2, which is now known as Oracle Developer/2000.

This book is intended to be of value to many different types of readers, including managers of Oracle client/server projects, individuals evaluating development tools, programmers who are new to the Oracle environment, experienced Oracle programmers who are new to the Windows development environment, and students interested in investing in their future careers in the Oracle application development job market........

Click to Read More

Sams Oracle Unleashed

SAMS Publishing

Introduction
When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. If you were an experienced Oracle developer three years ago and since then have been locked away—not able to see the new Oracle versions of the database and tools—there will be very little that you will recognize today. Along with changes in other computing technologies, the rate of change with Oracle is constantly increasing, which is all the more interesting for us who get turned on by the software. You'll get a running start with the pages that follow.

Oracle Unleashed is one of the most comprehensive books on Oracle and its tools available today. It's written by authors who have real-life experience using the Oracle tools (most of whom are members of the Oracle Business Alliance Program). We will show you what's important, the pitfalls, tips from real-life experiences, and code examples—The kind of information that can give you the cumulative experience of many years of expertise.

Click to Read More

Oracler Programming with Visual Basicr

Publisher: Sybex, Inc.

Author(s): Nick Snowdon

Why a Book on Oracle and Visual Basic?
This is an unusual book as far as computer literature goes in that it covers two quite separate areas of information technology. Many good books are available on Oracle, although nearly every one is designed as a source of information for database administrators. There are probably more books on Visual Basic than any other topic except perhaps the Web, but you will rarely see the word “Oracle” in the indexes. The lack of information is what I found myself dealing with a few years ago. Even with my strong background in Visual Basic (version 3 at the time), I found getting myself connected to an Oracle database and making it perform efficiently and effectively posed a problem that needed an answer.

This book is a personal one because it provides the resource I would have liked to have had a few years ago. It combines an understanding of the basic concepts about Oracle without which you will have a hard time communicating with database administrators or carrying out the administration role yourself if you are caught in that situation. (Oracle is not the simplest of databases to administer, which is something that is not always appreciated by project managers.)

Most Oracle texts are generally too complicated for the novice who has a hard time trying to decide which things are important enough to learn and which can be safely discarded until more time is available for training. Visual Basic books, on the other hand, are either introductory or deal exclusively with Microsoft SQL Server. So many questions are left unanswered for Oracle developers, even if it is just seeing an example of how something works.

The paucity of books for Oracle developers and the absence of any coverage of Oracle in the Visual Basic literature has led to the need for such coverage; this book will provide you with the information to proceed with your VB front ends to Oracle.

Click to Read More

Oracle Performance Tuning and Optimization

by Edward Whalen

Sams, Macmillan Computer Publishing

Introduction
Database management software and the manipulation of data has evolved to where it touches every aspect of our lives. A day doesn’t go by in which we don’t access a database. Whether we are withdrawing money from an ATM machine, opening a checking account, or purchasing groceries, every aspect of our lives is affected by databases. Hand in hand with the new power of information comes the frustration of having to wait for data to be retrieved. I’m sure there isn’t a person today who hasn’t had to wait for a credit card to be approved. Although the speed of computers has been increasing every year, so has the amount of data being manipulated. Amounts of data that several years ago were unheard of are now a daily part of many companies. In years past, databases were used strictly in the realm of big business because large mainframes cost millions of dollars; today, gigabytes of data are being manipulated on the same types of computer you may have in your own home.

No matter how fast new generations of computers get, applications will always be written to take advantage of them. As the cost of storage continues to drop, the amount of data stored will continue to increase. A perfect example of this is the CD-ROM. The advent of the CD-ROM allowed large amounts of data to be inexpensively stored; predictably, many new applications have arisen to take advantage of that technology. These applications are now augmenting written text with video and audio clips. The same type of information revolution is also happening in the database industry.

Oracle already has the capability to store video, documents, and large binary objects in the database and allow quick access to this data. Oracle databases can store hundreds of gigabytes of data and can easily retrieve it; Oracle has the potential of storing terabytes of data in a single database in the near future.

Click to Read More

Oracle 8 Black Book

Publisher: The Coriolis Group

Author(s): Michael R. Ault

Chapter 1—Provides an overview of relational and object-oriented terminology and technology. The Practical Guide provides concrete examples of how to apply these to database design. Actual conversion examples are given.

Chapter 2—Provides an overview of database structured design methodology. The Practical Guide demonstrates real-world application of the structured design concepts and provides a template for use in object-oriented diagramming.

Chapter 3—Discusses Oracle8 and how triggers are used to provide encapsulation and data hiding. Example triggers are shown, and the dreaded mutating table is slain.

Chapter 4—Discusses Oracle object/relational structures and insights into the use of the user-defined types. Comparisons to Java are utilized to demonstrate Oracle8’s object-oriented capabilities.

Chapter 5—Demonstrates Oracle8 data storage features. Partitioned tables, nested tables, VARRAYs, index-only tables, and LOB storage examples are given.

Chapter 6—Examines the new LOB features of Oracle8. Techniques for reading, inserting, and using LOB datatypes in the database are demonstrated including the DBMS_LOB package.

Chapter 7—Examines the PL/SQL enhancements specifically dealing with collection data types such as VARRAY and nested tables. The Practical Guide demonstrates the use of collection methods and data types.

Chapter 8—Deals with the new parallel and distributed options of Oracle8. Techniques for use of parallel insert, update, and delete are discussed and demonstrated. Advanced queuing is also discussed.

Chapter 9—Demonstrates how the Oracle8 data dictionary has been altered for the new features of Oracle8. The book’s companion appendix provides complete definitions of the major sets of data dictionary items such as the dollar ($), GV_$, and DBA_ views and tables. The Practical Guide shows how these tables and views are used to find information about Oracle8 objects.

Chapter 10—Provides information on application tuning with practical demonstrations of the use of Oracle provided tuning tools and scripts. All scripts discussed in Chapter 10 are provided on the com-panion CD-ROM, which also includes the Precise/SQL SQL-tuning tool from Precise Software Solutions.

Chapter 11—Provides information on tuning Oracle internals. The Practical Guide provides scripts, techniques, and guidelines for Oracle internal tunings. All scripts shown are provided on the companion CD-ROM along with the Q Diagnostic program from Savant Corporation.

Chapter 12—Covers the Oracle-supplied tuning and utility scripts, and demonstrates their use.

Chapter 13—Covers Oracle and Java topics. The Practical Guide shows examples of the use of Java with Oracle, including queries against the Oracle database using JDBC and JSQL, and the retrieval and display of objects (such as images) from the database. The companion CD-ROM contains the JDK1.1.4, JDBC, and JSQL development tool sets for use with Oracle8.

Appendix—Provides a reference for DBA_ and V$ views and ($) dollar tables.

Click to Read More

Subscribe to: Posts (Atom)

Ebooks Available

Free downloads in PDF format and online text/HTML version of study materials

CSS, HTML, Javascript, CGI, XML
CSS, HTML, Javascript, CGI, XML Ebooks and Tutorial (92).
Java
Core JAVA, J2EE, Advanced, J2ME, JSP Ebooks and Tutorial (100).
Unix/Linux
Unix and Linux Ebooks and Tutorial (87).
Shell Programming
Unix Linux Shell Programming Ebooks and Tutorials (31).
SAP/ABAP
SAP and ABAP Ebooks and Tutorial (52).
Computer Networking
Networking Ebooks and Tutorials (73).
CISCO
CCIE, CCNA, CCIP, CCNP, CCDP, CCSP Ebooks and Tutorial (21) & Ebook references (100).
Compilers
Compiler Ebooks and Tutorial (26).
.Net
ASP.NET, VB.NET, VB, VC++, ADO.NET, C#.NET Ebooks and Tutorial (42).
C#
C# Ebooks and Tutorial (22).
Database
Oracle, Mysql, Ms sql, sybase, db2 Ebooks and Tutorial (57).
Data Structure and Algorithms
Data Structure and Algorithms Ebooks and Tutorial (30).
Mainframe
Mainframe Ebooks and Tutorial (198).
Computer Hardware and Electronics
Computer Hardware(50)
Computer Graphics
Computer Graphics Ebooks and Tutorial (36).