Oracle8 Programming: A Primer [Paperback]

Rajshekhar Sunderraman (Author)

Book Description

ISBN-10: 0201612585 | ISBN-13: 978-0201612585 | Publication Date: December 1999 | Edition: 2nd

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.

Editorial Reviews

From the Inside Flap

Oracle is the most widely used database system in the world. It runs on virtually all platforms ranging from the PC to the mainframes. It also comes with an array of programming tools and environments and provides access to the database from a variety of high-level programming languages.

In recent years, more and more universities in the United States are using Oracle in their database courses as the primary vehicle to illustrate database concepts and principles. This has resulted in the need for a concise book on Oracle programming to supplement the traditional text in the database courses. The main motivation for writing this book is to satisfy this need. This book can also be used by a non-academic professional who is interested in learning about SQL, PL/SQL, embedded-SQL programming and JDBC in the context of Oracle.

The topics discussed in this book are Oracle SQL, PL/SQL, embedded programming with Pro*C and JDBC. To work with Oracle, it is absolutely essential to learn about SQL and PL/SQL, the two languages at the core of the Oracle database engine. Embedded-SQL (Pro*C) and JDBC access to Oracle are two of the important environments to develop applications in. Java is an emerging language which will have a signifcant impact in computing in the coming years and Oracle is investing in this technology by providing JDBC drivers and other tools to develop applications, expecially on the Web. Embedded- SQL is part of the SQL standards and is also an important technique for database programmers to learn.

Two sample databases are introduced early in the book and most of the chapters use these two databases for illustration purposes. Several application programs are developed in their entirety in the different programming environments discussed in the text.1. Book Use

This book is suitable as a supplemental text for an introductory database course which covers the relational model and uses Oracle as the database system for the course projects and assignments. Course projects can be developed using embedded-SQL (Pro*C) or JDBC. An entire chapter is devoted to suggestions for course projects. These course projects are typically assigned in introductory database courses where a team of students start with a problem statement, write the problem specifications, design the database, create the database in Oracle, and write application programs that access the database. Some of the chapters also have review problems for the reader to go over to consolidate their understanding of the concepts presented in these chapters.

This book is also appropriate for a non-academic individual who is interested in learning about Oracle. He or she can find materials on SQL, PL/SQL, Pro*C and JDBC, all in one text. This book can be considered a starting point in the exploration of what Oracle has to offer. World Wide Web Support

Most of the code presented in the book can also be found at the following World Wide Web site:
awl/cseng/
In addition, the author will attempt to include other related materials to be developed in the near future at this ftp site. Acknowledgements

First of all, I would like to acknowledge the persistence shown by Maite Suarez-Rivas at Addison-Wesley in encouraging me to write this book. Maite, along with Molly Taylor, Amy Wilcutt, Brooke Albright and Tom Ziolkowski at Addison-Wesley made the task of writing the book a pleasant experience for me. The reviewers, Louis Mazzucco (SUNY Institute of Technology), Panos Chrysanthis (University of Pittsburgh) and S. David Wu (Lehigh University) deserve special mention, as they made very useful and critical observations to improve the presentation and content of the book.

I would also like to acknowledge all my students who have diligently worked on various projects using Oracle over the past several years at Wichita State University and Georgia State University. Dr. Fred Massey, my departmental chair, also deserves special mention. His encouragement and genuine concern for my professional development has made my work at Georgia State University a pleasant experience. I would also like to acknowledge Dr. Mary Edgington at Wichita State University, who has always had a special place for me and my family in her heart.

Finally, I would like to acknowledge the support my family has shown to me during the writing of this book. Thank you, Radhu, for all the hardwork and understanding and thanks, Nannu and Nammi, for not troubling me too much while I was writing this book.

  _____

1 The programs and the applications presented in this book have been included for their instructional value. They have been tested with care but are not guaranteed for any particular purpose. The publisher does not offer any warranties or representations, nor does it accept any liabilities with respect to the programs or applications.

0201357534P04062001 --This text refers to the Textbook Binding edition.

From the Back Cover

0201612585B04062001

See all Editorial Reviews

Product Details

• Paperback: 334 pages
• Publisher: Addison-Wesley Pub (Sd); 2nd edition (December 1999)
• Language: English
• ISBN-10: 0201612585
• ISBN-13: 978-0201612585
• Product Dimensions: 9.2 x 7.5 x 0.6 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #2,297,473 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 12 people found the following review helpful:

5.0 out of 5 stars A great and precise book, October 16, 1999

By A Customer

This review is from: Oracle Programming: A Primer, Version 7.0 (Textbook Binding)

This is one of the shortest and perhaps the best book on Oracle programming. In just 250 pages, the author covers every major aspect of Oracle programming techniques. Do yourself a favor and get this valuable book.

4 of 4 people found the following review helpful:

5.0 out of 5 stars The best book for Oracle Programming, February 4, 2000

By A Customer

This review is from: Oracle Programming: A Primer, Version 7.0 (Textbook Binding)

I have read many Oracle Programming books. This one is certainly the best for beginners. It's concise, practical, well written, no-frills. It is very different from other books that are full of junks. The author made every page count (I fully agree with one of the reviewers).

One suggestion to the author: please write more books on Oracle.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Great book for programming, February 18, 2002

By 

praveen madiraju (Atlnata GA USA) - See all my reviews

This review is from: Oracle Programming: A Primer, Version 7.0 (Textbook Binding)

I have not seen any other book, which has so many sample databases to work with. The author gives many examples to help understand the concepts of SQL.Truly, a great book for programming and many tips for writing queries and JDBC concepts explained very well.Great coverage of PL/SQL.

I would recommend this book to anyone who would like to learn oracle programming.