Home > Store > Databases > SQL
Sams Teach Yourself PL/SQL in 21 Days, 2nd Edition
- By Jonathan Gennick, Tom Luers
- Published Dec 22, 1999 by Sams. Part of the Sams Teach Yourself series.
- Copyright 1999
- Dimensions: 7.375 X 9.125
- Pages: 720
- Edition: 2nd
- Book
- ISBN-10: 0-672-31798-2
- ISBN-13: 978-0-672-31798-9
- eBook (Adobe DRM)
- ISBN-10: 0-7686-6050-5
- ISBN-13: 978-0-7686-6050-0
Register your product to gain access to bonus material or receive a coupon.
Annotation
Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.
PTR Bullets
- Revised to include the new features of Oracle 8i--Oracle's biggest release yet
- The only book to present PL/SQL in an easy to learn, tutorial style
- Will appeal to users of many different Oracle tools including Oracle 8i Application Server and Developer 2000
Audience
This book is must have for the professional developer moving into an Oracle environment who needs to learn PL/SQL quickly and easily, or database administrators who want to increase their productivity with PL/SQL.
User Level
Beginner - Intermediate
PTR Overview
Sams Teach Yourself PL/SQL in 21 Days Second Edition will quickly empower the reader to create their own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading the programmer through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include Extented dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, Use of invoker's rights, Autonomous Transactions, Interfacing PL/SQL with Java, PL/SQL Bulk Binds, Parameter passing by reference, and Advanced Queueing.
Product Author Bios
Jonathan Gennick is a professional developer with over seven years of experience working with relational database technology. As the lead database administrator for the utilities group of KPMG, Jonathan¿s duties include assisting programmers who need to write stored procedures and database triggers using Oracle PL/SQL. A member of MENSA, Jonathan holds a degree in Information & Computer Science from Andrews University in Berrien Springs, Michigan. His writing career began in 1997, when co-authored Teach Yourself PL/SQL in 21 Days. Since then he has been involved with four other book projects, serving as technical editor for Oracle8 Server Unleashed, the development editor for Sams Teach Yourself Access 2000 in 24 Hours, a technical reviewer for Oracle Database Administration, The Essential Reference, and the author of SQL*Plus, the Definitive Guide.
Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.
Downloads
Sample Files
Source Code from the book - 92kb -- plsqlcode.exe
Additional Electronic Chapters - 287kb -- pssql.exe
Technology
PL/SQL, Oracle's implementation of the SQL language, is supported widely across the Oracle product line. It is used in Developer 2000 to code field validations, responses to mouse-clicks, responses to button pushes, and so forth. It is used with the Oracle Application Server to implement application logic. It is also used extensively to write stored procedures and functions that will reside and execute within the database. Oracle continues to support and enhance this language with each new product release.
|
28 of 28 people found the following review helpful
2 Authors -- one good, one really, really bad, By
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
After reading the first 3 chapters of this book, I was thinking to myself "Wow! This book is great". However, moving on to chapter 4, it felt like a bus fell on me. I read the next few chapters in stunned amazement, wondering what happened, and then I discovered it -- the first three chapters had been written by a different author than the current chapters that I was struggling through.Where the first chapters, written by Jonathan Gennick, had pertinent, precise examples and a good development of the subject matter, the subsequent chapters (4-9), written by Tom Luers, contained error after error with poor development of the subject matter. The naming of variables was confused and the case of variables and keywords changed from example to example (and even within the same example!). When I started reading this book, I typed all the examples into Personal Oracle to experiment along with the text. In addition, I placed small "sticky" notes on each page where... Read more
23 of 24 people found the following review helpful
Good for CompSci majors considering an OCP, By
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
I generally agree with the other reviewers on this book - despite some errors, it is a solid set of PL/SQL lessons. Great results can be produced by using the book as designed (download a copy of Personal Oracle, and spend three hours a day hacking the &@:=#! out of it). However, these favorable reviews can be misleading, as they lack a "Who is this book for?" section. Unlike many "Teach Yourself" titles, this is not good reading for the absolute novice. To get the most from this book, you should have:1. Functional and theoretical knowledge of at least one high-level programming language. 2. A good understanding of database theory and terminology. 3. Some experience with SQL (and ideally with Oracle, but if you can make Access do tricks, you'll be fine). 4. Three weeks off. ;-)
15 of 15 people found the following review helpful
Gets the job done, By
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
This book is pretty good. Each of the 21 lessons takes a couple of hours to read, so the pace is about right. I learned a lot of PL/SQL from this book, so I'm glad I bought it.The book is pooly edited, though, and is full of errors. A couple of times there were serious errors in the example programs, but they weren't enough to spoil the book. If you have a little programming experience, you might try just using the PL/SQL chapters in the Oracle8: The Complete Reference. You're going to need a book like that anyway.... |
This book includes free shipping!
This book includes free shipping!
eBook (Adobe DRM)
$31.99
$25.59
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
