Free Downloads
ORACLE PL/SQL 101 (Oracle Press)

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.

File Size: 8263 KB

Print Length: 420 pages

Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits

Publisher: McGraw-Hill Education; 1 edition (December 22, 2000)

Publication Date: December 22, 2000

Language: English

ISBN-10: 0072192291

ISBN-13: 978-0072192292


Text-to-Speech: Enabled

X-Ray: Not Enabled

Word Wise: Not Enabled

Lending: Not Enabled

Enhanced Typesetting: Not Enabled

Best Sellers Rank: #1,165,901 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #139 in Books > Computers & Technology > Certification > Oracle #140 in Books > Computers & Technology > Databases & Big Data > Relational Databases #542 in Books > Computers & Technology > Databases & Big Data > Oracle

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).

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.

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.

This is the best introduction I've seen to PL/SQL programming. The book takes its "101" moniker seriously - it doesn't assume anything, but explains fully everything you need to know to learn how to program in PL/SQL. Since PL/SQL relies on a fundamental knowledge of SQL, the book invests a good deal of time covering the database concepts, SQL concepts, and SQL commands necessary to write good PL/SQL code. Bravo! That's why this deserves to have "101" in its title.Those who already have some SQL knowledge would do well to read over these SQL chapters anyway - the book really pulls things together, filling in the gaps that often come with self-teaching. It also has great examples for some of the more obscure features of SQL and PL/SQL.Perhaps the author can be persuaded to do a "PL/SQL 201" book - I would buy it.

JOB WELL DONE Mr. Christopher Allen!! This is the MOST helpful book to me on Oracle Pl/ SQL that I have ever seen in Silicon Valley area! I have spent many months browsing and buying books on Oracle from almost all bookstores in the bay area, but this book is the only one that helped me. I am very thankful for that. Abdullahi Koshin from Oakland, CA

Since I've been working on Oracle for a couple of years, I was not really expecting too much from this book when I got it from the public library. However, when I read it last night, it refreshed a lot of concepts for me and taught me some *very* useful tricks I never knew before.I agree that this book is very useful for beginners since it explains everything crystal clear. e.g. the way it explained To_Date and To_Char function is a lot better than all the oracle books I've read, including Oracle 8i: The complete reference, which is one of the all time Oracle best sellers.If you like to go one step further on PL/SQL after read this book, I would suggest Advanced Oracle PL/SQL programming by Scott Urman. Although it has 'Advanced' in its title, that book is actually quite beginner friendly. And Scott has long been one of my most favorite writers. You won't waste your money on that one...

Great book for new Oracle DBAs learning how to write SQL statements and queries. I worked through the book chapter by chapter. The first two sections ("Database Basics" and "Advanced SQL") are very strong, with clear instructions and a logical progress from simple to more complex steps. However, the third section, "Creating Programs using PL/SQL", falls short. Here the material gets too complex too quickly.

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) ORACLE PL/SQL 101 (Oracle Press) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 11g SQL (Oracle Press) Oracle SQL Tuning with Oracle SQLTXPLAIN Effective MySQL Optimizing SQL Statements (Oracle Press) Pro SQL Server 2012 BI Solutions (Expert's Voice in SQL Server) SQL: The Ultimate Beginners Guide: Learn SQL Today SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL Head First SQL: Your Brain on SQL -- A Learner's Guide SQL Handbook: Learning The Basics Of SQL Programming (Computer Science Programming) (Computer Programming For Beginners) SQL and Relational Theory: How to Write Accurate SQL Code Programming: Computer Programming for Beginners: Learn the Basics of Java, SQL & C++ - 3. Edition (Coding, C Programming, Java Programming, SQL Programming, JavaScript, Python, PHP) Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server)