Oracle Pl/SQL Programming (Oracle Series) [Paperback]

Scott Urman (Author), Tim Smith (Author)

Book Description

Series: Oracle Series | Publication Date: April 23, 1996

This one-of-a-kind applications development guide teaches Oracle developers the ins and outs of using PL/SQL in client/server applications. PL/SQL is the key to building successful client/server applications for Oracle 7. It combines the data processing power of procedural language with the data manipulating power of a query language. The book explains how to develop, test, debug, and tune Oracle applications using such popular tools as Visual Basic, SQL, and Oracle Developer/2000. It also provides expert advice on transaction design, distributed processing, application security, and lots more, with helpful illustrations throughout.

Editorial Reviews

From the Back Cover

ORACLE PL/SQL Programming Expert Advice to Help You Develop, Test, Debug, and Tune Your Oracle PL/SQL Applications. Oracle7 programmers, take note: The secrets to building robust client/server applications that take full advantage of the Oracle7 server are revealed in this book. Written by Oracle insider Scott Urman, this guide will have you expertly programming for Oracle7 with PL/SQL-the language that combines the power of procedural programming with the flexibility of the SQL query language. The book begins with an overview of PL/SQL and the rationale behind its development. It then continues to build your Oracle7 PL/SQL skills with: A solid foundation in the basics of PL/SQL, including the syntax and semantics of this unique language, as well as an understanding of SQL. Advice on using stored procedures and packages, to help you take advantage of these powerful Oracle feataures. Tips and techniques for testing and debugging your PL/SQL code, using a variety of methods and tools; Instructions on using PL/SQL in diverse environments such as SQL*Plus, Oracle Developer 2000, the Oracle Precompilers, and OCI. Information about advanced features such as dynamic programming, intersession communication, and job scheduling. Also included are the latest enhancements available in version 2.3, such as file input/output and cursor variables; suggestions for tuning and optimizing your PL/SQL applications to make them run fast as possible. Everything in this book is presented in clear language, with many helpful illustrations and code samples to get you going immediately with your own full-featured PL/SQL applications. Remember, when it comes to learning how to program for Oracle7 with PL/SQL, Oracle PL/SQL Programming is the only book that puts you on the inside track. Whether you're a novice programmer or an experienced systems analyst, this is your essential guide for building successful client/server applicatgions using Oracle's powerful development tool-PL/SQL.

Product Details

• Paperback: 564 pages
• Publisher: Oracle Pr (April 23, 1996)
• Language: English
• ISBN-10: 0078821762
• ISBN-13: 978-0078821769
• Product Dimensions: 8.8 x 7.3 x 1.4 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 4.9 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #1,877,281 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

15 of 15 people found the following review helpful:

5.0 out of 5 stars Excellent for beginners, February 28, 2000

By 

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

This review is from: Oracle Pl/SQL Programming (Oracle Series) (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.

9 of 9 people found the following review helpful:

5.0 out of 5 stars An Excellent Book, February 2, 1999

By A Customer

This review is from: Oracle Pl/SQL Programming (Oracle Series) (Paperback)

This is definitely an excellent book. No one should rank it less than 5 stars just because it was published in 1996. Please do some research before talk. Actually, Scott Urman has wrote a book, "Oracle8 PL/SQL Programming", which was published in 1997. Buy this one if you want to learn PL/SQL 8.0.

9 of 10 people found the following review helpful:

3.0 out of 5 stars Good but outdated, January 27, 1999

By A Customer

This review is from: Oracle Pl/SQL Programming (Oracle Series) (Paperback)

Oracle 8 is out and in this book it only covers to Oracle 7. It is a very well written book. It is a valuable reference however it was published in 1996. Still looking for Oracle SQL Plus 8.0 AND the PL/SQL Programming. I hope the author steps up to the plate and updates his work.