This concise introduction to Oracle SQL is ideal for students in a database course that requires programming SQL. This book covers the basics of Oracle and includes new topics associated with web server programming. This v.8 edition includes new material on Pro*C++ and a new chapter on SQLJ (a new Java interface to Oracle and other databases). Oracle 8 Object features have also been added, and all of the book's examples are updated to reflect Oracle 8. The final chapter is composed of a number of sample projects and programming applications that implement these basic concepts.* Introduces a new database (Investment Portfolio Database) in Ch. 1. * Includes new material on Pro*C++ and a new chapter on SQLJ. * Devotes separate chapters to JDBC (in the context of Oracle) and embedded-SQL (PRO*C). * Includes an extensive selection of problems and project suggestions, all updated to reflect Oracle 8. * Contains new exercises at the end of each chapter and new projects added to Chapter 7.
An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.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 Oracle's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. The book contains chapters on: Oracle products, options, and overall architecture for Oracle 10g and prior recent releases Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes) Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery Oracle performance: characteristics of disk, memory, and CPU tuning Multi-user concurrency, online transaction processing (OLTP), and high availability Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing and distributed databases Network deployment: using Oracle as an Internet computing platform and for grid computing What's new in Oracle 10g: a summary of the database changes described in the book Oracle Essentials, 3rd Edition: Oracle Database 10g was written for anyone whose job involves managing or building systems using Oracle DBMS technology or working with staff that uses Oracle technology. This book is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.
One of the only Oracle books to focus exclusively on database programming rather than administration Oracle owns sixty percent of the commercial database market Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL
Gain braids together two stories on very different scales. In one, Laura Body, divorced mother of two and a real-estate agent in the small town of Lacewood, Illinois, plunges into a new existence when she learns that she has ovarian cancer. In the other, Clare & Company, a soap manufacturer begun by three brothers in nineteenth-century Boston, grows over the course of a century and a half into an international consumer products conglomerate based in Laura's hometown. Clare's stunning growth reflects the kaleidoscopic history of America; Laura Body's life is changed forever by Clare. The novel's stunning conclusion reveals the countless invisible connections between the largest enterprises and the smallest lives.
The previous three editions have established Fluid Mechanics as the key textbook in its field. This fourth edition continues to offer the reader an excellent and comprehensive treatment of the essentials of what is a truly cross-disciplinary subject, while also providing in-depth treatment of selected areas. This book is suitable for all students of civil, mechanical, chemical, environmental and building services engineering.The fourth edition retains the underlying philosophy of the previous editions - guiding the reader from the general to the particular, from fundamentals to specialist applications - for a range of flow conditions from bounded to free surface and steady to time dependent. The basic 'building block' equations are identified and their development and application to problems of considerable engineering concern are demonstrated and discussed.The fourth edition of Fluid Mechanics includes: end of chapter summaries outlining all essential concepts, an entirely new chapter on the simulation of unsteady flow conditions, from free surface to air distribution networks, enhanced treatment of dimensional analysis and similarity and an introduction to the fundamentals of CFD
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.