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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

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)

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.

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.

2001-2011 Oracle-Books.com