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.

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.

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

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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

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.

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