- Paperback: 440 pages
- Publisher: Osborne/McGraw-Hill (1 Dec 2000)
- Language English
- ISBN-10: 007212606X
- ISBN-13: 978-0072126068
- Product Dimensions: 22.6 x 18.5 x 3 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
1,299,967 in Books (See Top 100 in Books)
- #62 in Books > Computers & Internet > Computer Science > Databases > Applications > Oracle > PL & SQL
- See Complete Table of Contents
Oracle PL/SQL 101 (Oracle Press)
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Product Description
This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.
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
Inside This Book
(Learn More)
First Sentence
Welcome to the wonderful world of databases. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Welcome to the wonderful world of databases. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Customer Reviews
Most Helpful Customer Reviews
10 of 10 people found the following review helpful
Format:Paperback
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.
5 of 5 people found the following review helpful
Format:Paperback
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.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
77 reviews
13 of 13 people found the following review helpful
A perfect book for a newcomer to PL/SQL
23 Jan 2001
Format:Paperback
I enjoyed reading the PL/SQL 101 thoroughly, I have finished one complete reading of the book and now I am going through it the second time. I decided to buy this book after getting totally frustrated of asking others to help me with Oracle. I asked our dedicated Oracle DBA to show me how to create a simple table, it took me more than three months to chase her and could not get any result and one day I found out she was gone, then I bought the PL/SQL 101 and in chapter one the author explains the most basic way to get going.
Remember this is a 101 book, if you already know quite a bit of SQL, then this book might bore you. The title is perfect, and its readers should of that level.
I would like to thank the author for getting me hooked to Oracle and PL/SQL the easy way (Ofcourse there is no easy way, you still have to read and reread the book several times, and practice and practice).
10 of 10 people found the following review helpful
Perfect introduction to Oracle PL/SQL
12 Oct 2001
Format:Paperback
It's right there on the cover: Oracle PL/SQL. And that's what this book explains, from the very beginning. You can't learn PL/SQL without knowing SQL, so a substantial portion of the book covers SQL techniques that are necessary to write good PL/SQL code.
Each chapter has dozens of exercises, so by the end of the book you have worked through hundreds of experiments, samples, and exercises. It's all hands-on.
The sections on PL/SQL programming cover functions, procedures, packages, and triggers...all the tools you need to make Oracle dance to your tune.
9 of 9 people found the following review helpful
Excellent place to start for PL/SQL
6 Sep 2001
Format:Paperback
This is one of the best books that I've bought recently. I've been a programmer for 4 years, but I just recently started working with relational databases, specifically Oracle. This book is clear, concise, and very accessible. The writing style is very engaging, too. The author manages to present the material in a way that keeps your interest without sacraficing quality. Consequently, the book is fast to read, but of great value.
The chapter on using SQL*Plus is of great value. It helped me to more effective look at what is in our databases to get a feel for the results from the programs that I was testing.
After reading this book I felt like the author gave a solid overview of the PL/SQL language without being overly rigorous. If you are looking for an academic treatment with lots of theory, this is not the place. Those books are very import to broaden your understanding, but this book bridges the gap to make the advance texts accessible.
This is the place for Oracle beginners to get their hands dirty. There are plenty of examples that run throughout the book to demonstrate the concepts. As you work with PL/SQL and SQL*Plus, you will find yourself referring back to this book often as you come up to speed. It is definitely worth the money and the time.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
