Oracle8 PL/SQL Programming [Paperback]

Scott Urman (Author), Wendy Rinaldi (Editor)

Book Description

ISBN-10: 0078823056 | ISBN-13: 978-0078823053 | Publication Date: September 1, 1997

Designed for both the novice programmer as well as the experienced systems engineer, this text seeks to show the reader how to develop, test, debug and tune Oracle applications using Visual Basic, SQL/Windows and developer/2000. New features such as LOBs and ADTs are integrated throughout the book. It also includes common business problems and their solutions using PL/SQL, using real-world examples where applicable. PL/SQL is Oracle's extension to the SQL query language. the "PL" stands for "Programming Language", which is what PL/SQL adds to SQL. With PL/SQL users get tools traditionally available in third-generation languages, such as C or Cobol. These include such things as database triggers and stored procedures. The combination of PL/SQL and SQL gives users a powerful development language, with which one can do much more complex and powerful manipulations of data stored in an Oracle database. PL/SQL is available from all Oracle development tools, including Developer and Designer/2000, the Oracle pre-compilers and in the Oracle7 server itself. The new relational features of PL/SQL 3.0 should be easy to learn for those who are familiar with Version 2.0 and Oracle7. The object-oriented features may be more difficult, but are still straightforward.

Editorial Reviews

From the Back Cover

Speak the Language of PL/SQL 8.0 for Oracle8.

Become fluent in the powerful Oracle8 development language and create applications that exude efficiency, reliability, and grace. This completely revised and updated book and CD-ROM package is your ticket to mastering PL/SQL in Oracle7 and Oracle8.

An Oracle insider, Scott Urman presents up-to-date information on the best ways to develop, test, debug, and tune your Oracle7 and Oracle8 PL/SQL applications, with an emphasis on critical server-side techniques. Beginning with an overview of PL/SQL and general programming constructs, you'll receive valuable guidance so you can:

• Minimize the time spent learning PL/SQL--get clear, concise examinations of the essential features that all Oracle developers, programmers, and DBAs must know
• Understand how PL/SQL 8.0 interacts with the new object relational database, Oracle8
• Become fluent in new, advanced PL/SQL 8.0 features, such as large objects and abstract data types
• Find solutions to your common business problems using real-world examples of PLSQL at work
• Learn how to expertly test and debug your PL/SQL code suing a variety of methods and tools, including Platinum's SQL-Station
• Find out how to use PL/SQL with third-party tools, and in such diverse environments as Oracle Developer/2000 and the Oracle Application Web Server
• Discover rich resources on the CD-ROM, including ready-to-use code from the book, and demo versions of Platinum's SQL-Station and Oracle's Web Server

Take your applications from specifications from specification to brilliantly working code in no time with Oracle8 PL/SQL Programming.

About the Author

Scott Urman (Foster City, CA) is a senior member of the diagnostic and defect technical staff in the Language Group of Oracle Support Services, where he aids users of Oracle's various language products (PL/SQL, OCI, and the Oracle precompilers). In addition, he reviews Oracle technical documentation, writes white papers on Oracle languages, and makes technical presentations both inside Oracle and at meetings of Oracle User's Groups. Scott is the best-selling author of Oracle Press' Oracle PL/SQL Programming and Oracle8 PL/SQL Programming.

Product Details

• Paperback: 1022 pages
• Publisher: Oracle Press (September 1, 1997)
• Language: English
• ISBN-10: 0078823056
• ISBN-13: 978-0078823053
• Product Dimensions: 9.1 x 7.4 x 2.5 inches
• Shipping Weight: 4 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (29 customer reviews)
• Amazon Best Sellers Rank: #2,008,170 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

41 of 41 people found the following review helpful:

5.0 out of 5 stars Excellent for beginners and experts alike..., March 1, 2000

By 

nullptr "nullptr" (Seattle, Washington) - See all my reviews

This review is from: Oracle8 PL/SQL Programming (Paperback)

I bought this book as a complete Oracle novice, transitioning from Microsoft T-SQL to PL/SQL. I was worried about the transition being difficult until I read this book.

It is one of those very rare books that presents advanced concepts in a context understandable by users of all experience levels. The author often throws in tips about Oracle PL/SQL quirks to watch out for, as well as some very applicable information about how Oracle works internally.

I've since become more comfortable with PL/SQL, and the book also serves as a great reference. I highly encourage you to read this book straight through.

I recommend this well-written book to anybody wanting to learn PL/SQL, as well as anyone needing a great reference.

27 of 27 people found the following review helpful:

5.0 out of 5 stars One the Best Documents on Oracle 8 PL/SQL features, June 17, 1998

By 

Golden Lion "Reader" (North Ogden, Ut United States) - See all my reviews
(VINE VOICE)   

This review is from: Oracle8 PL/SQL Programming (Paperback)

I found "Oracle8 Pl/Sql Programming" to be worth my time and money. Reading the "Oracle8 Pl/Sql Programming" book was like being in the Oracle Education course without paying $2000. Here's why - each chapter has short narrative descriptions of the topics followed by a lab you can do. I like the learn by experimentation approach. Beneficial topics were: Oracle Objects, Collections, DBMS_OUTPUT, TEXT_IO, cursors, and Dynamic cursors. I found "Oracle8 PL/SQL Programming" far superior to the Oracle documentation.

6 of 6 people found the following review helpful:

5.0 out of 5 stars This is how ORACLE books should be written., April 19, 2000

By 

Riad Thalji - See all my reviews

This review is from: Oracle8 PL/SQL Programming (Paperback)

The book is plentiful of carefully selected examples, which illustrate each topic in a very clear and real-life simulation. The complete sections of practical real-life examples found at the end of some chapters are very useful and can be modified and used in practical applications. It is really a great job. Buy this book. It is really a great job.