Oracle 10g Programming

Oracle 10G Programming is a concise, streamlined guide to Oracle programming. It is ideal for students studying databases, and introduces the Oracle technology students need to know for a first database course. This easily accessible primer is divided into two sections for ease of use. The first part of this book offers a basic review of the relational model and an introduction to Oracle SQL and PL/SQL. The second part introduces related technologies that facilitate Oracle Web functionality. There are chapters on SQLJ, Oracle Web programming with Java Servlets, and Oracle XML. The final chapter of this book is composed of a number of sample projects and programming applications that implement the basic concepts covered in this brief primer.Includes concise coverage of basic Oracle SQL programming and Web connectivity. Covers advanced topics such as SQLJ, PL/SQL, JDBC, PSP, Java Servlets, and Oracle XML. Three continuous sample databases-grade book, mail order, and portfolio databases-are introduced early in the book and used throughout the text to illustrate key concepts. Suggested database projects readers can use to practice covered concepts are presented in the final chapter. End-of-chapter exercises ask students to apply the concepts of the chapter to the three running database examples.