Professional Oracle Programming (Programmer to Programmer)

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 Annotation Professional Oracle ProgrammingIf you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications. After an overview of the topics you need to know in order to use the Oracle database effectively, you'll get helpful tips, techniques, code samples, and examples written in Oracle Database 10g. Along the way, you'll learn how to access and manipulate data in the Oracle database, implement logic with various programming techniques, use raw data in a database, and, ultimately, create successful applications. What you will learn from this bookHow to leverage Oracle's strengths in both its functionality and operationsVarious database issues that have a direct impact on the operation and performance of Oracle applicationsTechniques for using triggers, regular expressions, object types, XML, and HTML-DB with OracleHow Oracle processes SQL requests and the implication this can have on application codeWays Oracle determines optimal access paths to data and how to shape the behavior of an Oracle databaseWho this book is forThis book is for anyone whose primary job is to create application systems and who wants to use the Oracle database for such systems. A basic knowledge of Oracle, Java, and SQL is recommended. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job The core theoretical purpose of a relational database is to separate logical interaction with data within the database from the physicaI storage of that data.