Product Description

This is a guide designed to introduce the reader to SQL and PL/SQL, in order to write flexible, powerful programs which perform quickly and automate a multitude of database tasks.

---

Product Details

• Amazon Sales Rank: #858061 in Books
• Published on: 2000-12-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 420 pages

From the Back Cover

Learn to use SQL and PL/SQL in your Oracle database.

Get step-by-step details on performing database tasks quickly and easily.

Oracle PL/SQL 101 explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL. You'll learn by doing each chapter contains hands-on exercises designed to teach the concepts presented. This easy-to-follow book starts with database basics and then teaches how to store, retrieve, and manipulate data, control SQL-Plus, create and use SQL functions, and write PL/SQL programs.

-Understand the key components of a database tables, rows, records, columns, and fields

-Create database tables, indexes, and constraints

-Write SQL commands to insert, select, update, and delete data

-Perform advanced data manipulation

-Write complete PL/SQL functions and procedures

-Declare variables using anchored types

-Create PL/SQL packages

-Use triggers to enforce complex business rules and security measures

About the Author
Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

---

Customer Reviews

If you want to get into PL/SQL, this is THE book to get!
This book is without doubt the best start up book I have read about pl/sql. I have bought many books before which jump straight into pl/sql with the assumption that the reader has a good knowledge of SQL. What this book does is provide clear and detailed explanations on all the necessary areas. The author makes the reader type out all the statements as well, so you are not just reading but doing as well. For anyone looking to learn about pl/sql, buy this book first and then start looking at the others.

Good on SQL not so on PL/SQL
Well... my title summary says it all. As a recent convert from a technophobe to an Oracle developer I was looking for a book I'd use a lot writing prcedures and functions. But after reading it on my holidays I recon it should've been billed as "Learn to Write Powerful SQL Queries". Christopher Allen is experienced and funny in what he writes, and if you are new to SQL thing that's the book that won't make you feel supid, on the contrary, it'll help you to absorb the stuff quickly and painlessly... but if you are after PL/SQL.. stop reading this now and go investigate more in-depth PL/SQL publications.