Christopher Allen Oracle PL/SQL 101

ISBN 13: 9780072126068

Oracle PL/SQL 101

 
9780072126068: Oracle PL/SQL 101

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.

"synopsis" may belong to another edition of this title.

From the Author:

Not too long ago my lovely wife decided she wanted to learn more about SQL and Oracle. I thought that was a great idea, so I gave her the 3 or 4 books I had on SQL and PL/SQL, and we bought 2 or 3 more as time went on. By this time we had just about every major SQL book on the market. In the months that followed we both came to the conclusion that while the books contained lots of information, none of them seemed to be written for a beginner. Many assumed prior knowledge of SQL, Oracle, or a programming language like C++. They offered plenty of examples producing results that had no particular value, and many of the books jumped around from topic to topic without bringing everything together into a bigger picture that relates to normal work life.

What I present here is my best effort at explaining SQL and PL/SQL in a way that makes sense. I have worked to create examples that demonstrate not only how to use each feature, but also why. I’ve provided exercises that mirror the kinds of tasks you’ll be asked to accomplish if you make SQL and PL/SQL part of your work. And I’ve done my best to make the writing reasonably interesting to read, so your flame of interest in this fascinating topic stays burning.

All the best in your SQL endeavors,
Christopher Allen

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 this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Christopher Allen
Published by McGraw-Hill Osborne Media (2000)
ISBN 10: 007212606X ISBN 13: 9780072126068
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2000. Paperback. Book Condition: New. book. Bookseller Inventory # 007212606X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 37.80
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Christopher Allen
ISBN 10: 007212606X ISBN 13: 9780072126068
New Paperback Quantity Available: 1
Seller
AMAZINGBOOKDEALS
(IRVING, TX, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: BRAND NEW. BRAND NEW. Fast Shipping. Prompt Customer Service. Satisfaction guaranteed. Bookseller Inventory # 007212606XBNA

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 35.46
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Allen, Christopher
Published by McGraw-Hill Osborne Media (2000)
ISBN 10: 007212606X ISBN 13: 9780072126068
New Paperback Quantity Available: 2
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2000. Paperback. Book Condition: New. Bookseller Inventory # P11007212606X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 39.22
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

4.

Christopher Allen
Published by McGraw-Hill Osborne Media (2000)
ISBN 10: 007212606X ISBN 13: 9780072126068
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2000. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX007212606X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 42.14
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

Allen, Christopher
Published by McGraw-Hill Osborne Media (2000)
ISBN 10: 007212606X ISBN 13: 9780072126068
New Quantity Available: 1
Seller
Nearfine Books
(Brooklyn, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2000. Book Condition: new. Shiny and new! Expect delivery in 20 days. Bookseller Inventory # 9780072126068-1

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 52.99
Convert Currency

Add to Basket

Shipping: US$ 4.00
Within U.S.A.
Destination, Rates & Speeds

6.

Christopher Allen
ISBN 10: 007212606X ISBN 13: 9780072126068
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800721260681.0

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 56.67
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Allen, Christopher
Published by McGraw-Hill Osborne Media
ISBN 10: 007212606X ISBN 13: 9780072126068
New PAPERBACK Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media. PAPERBACK. Book Condition: New. 007212606X New Condition. Bookseller Inventory # NEW6.0927382

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds