25 Women to Read Before You Die
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Q&A | August 26, 2015

    Christopher Moore: IMG Powell’s Q&A: Christopher Moore



    Describe your latest book. Secondhand Souls is the sequel to my bestselling novel A Dirty Job, which was about a single dad in San Francisco who... Continue »
    1. $18.89 Sale Hardcover add to wish list

      Secondhand Souls

      Christopher Moore 9780061779787

    spacer
Qualifying orders ship free.
$3.25
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- Applications

This title in other editions

Oracle PL/SQL Interactive Workbook

by

Oracle PL/SQL Interactive Workbook Cover

 

Synopses & Reviews

Publisher Comments:

  • Build Oracle PL/SQL applications—now.
  • Fully updated for Oracle 9i
  • No Oracle PL/SQL experience necessary.
  • Real-life labs and "Test Your Thinking" Q&As

Start developing applications with Oracle PL/SQL—fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals—and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging—plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates.

Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site.

Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:

  • "Test Your Thinking" project solutions and detailed explanations
  • Additional self-review exercises with instant feedback and explanations
  • An exclusive Virtual Study Lounge where you can interact with other students.

Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work.

Dozens of exercises cover the real-world tasks that matter most.

Hundreds of self-review questions and answers make sure you understand.

Book News Annotation:

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Master Oracle Pl/SQL fast with this complete book-and-Web hands-on course. The authors cover syntax, iterative control, scoping, cursors, triggers, security, and more. "Test Your Thinking" projects feature hundreds of self-review questions and exercises.

Synopsis:

Oracle PL/SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i PL/SQL skills you need, hands-on, through labs, exercises, projects, and a complete Web-based training site! Master syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, packaging, exceptions, cursors, collections, records, and more. Free Web training module includes Virtual Study Lounge: interact with other learners, work on new projects, and get updates.

Table of Contents

Acknowledgments.

About the Authors.

Introduction.

1. Programming Concepts.

LAB 1.1 The Nature of a Computer Program and Programming Languages. LAB 1.2 Good Programming Practices. Chapter 1 Test Your Thinking.

2. PL/SQL Concepts.

LAB 2.1 PL/SQL in Client-Server Architecture. LAB 2.2 PL/SQL in SQL*Plus. Chapter 2 Test Your Thinking.

3. General Programming Language Fundamentals.

LAB 3.1 PL/SQL Programming Fundamentals. Nested Blocks, and Labels. Chapter 3 Test Your Thinking.

4. SQL in PL/SQL.

LAB 4.1 Making Use of DML in PL/SQL. LAB 4.2 Making Use of SAVEPOINT. Chapter 4 Test Your Thinking.

5. Conditional Control: IF Statements.

LAB 5.1 IF Statements. LAB 5.2 ELSIF Statements. LAB 5.3 Nested IF Statements. Chapter 5 Test Your Thinking.

6. Conditional Control: Case Statements.

LAB 6.1 CASE Statements. LAB 6.2 CASE Expressions. LAB 6.3 NULLIF and COALESCE Functions. Chapter 6 Test Your Thinking.

7. Error Handling and Built-In Exceptions.

LAB 7.1 Handling Errors. LAB 7.2 Built-In Exceptions. Chapter 7 Test Your Thinking.

8. Iterative Control.

LAB 8.1 Simple Loops. LAB 8.2 WHILE Loops. LAB 8.3 Numeric FOR Loops. LAB 8.4 Nested Loops. Chapter 8 Test Your Thinking.

9. Introduction to Cursors.

LAB 9.1 Cursor Manipulation. LAB 9.2 Using Cursor FOR Loops and Nesting Cursors. Chapter 9 Test Your Thinking.

10. Exceptions.

LAB 10.1 Exception Scope. LAB 10.2 User-Defined Exceptions. LAB 10.3 Exception Propagation. Chapter 10 Test Your Thinking.

11. Exceptions: Advanced Concepts.

LAB 11.1 RAISE_APPLICATION_ERROR. LAB 11.2 EXCEPTION_INIT Pragma. LAB 11.3 SQLCODE and SQLERRM. Chapter 11 Test Your Thinking.

12. Procedures.

LAB 12.1 Creating Procedures. LAB 12.2 Passing Parameters In and Out of Procedures. Chapter 12 Test Your Thinking.

13. Functions.

LAB 13.1 Creating and Using Functions. Chapter 13 Test Your Thinking.

14. Packages.

LAB 14.1 The Benefits of Utilizing Packages. Chapter 14 Test Your Thinking.

15. Advanced Cursors.

LAB 15.1 Using Parameters with Cursors and FOR UPDATE Cursors. LAB 15.2 Cursor Variables. Chapter 15 Test Your Thinking.

16. Stored Code.

LAB 16.1 Gathering Stored Code Information. Chapter 16 Test Your Thinking.

17. Triggers.

LAB 17.1 What Triggers Are. LAB 17.2 Types of Triggers. LAB 17.3 Mutating Table Issues. Chapter 17 Test Your Thinking.

18. Collections.

LAB 18.1 PL/SQL Tables. LAB 18.2 Varrays. LAB 18.3 Multilevel Collections. Chapter 18 Test Your Thinking.

19. Records.

LAB 19.1 Records. LAB 19.2 Nested Records. LAB 19.3 Collections of Records. Chapter 19 Test Your Thinking.

Appendix A. Answers to Self-Review Questions.

Appendix B. PL/SQL Formatting Guide.

Appendix C. Student Database Schema.

Appendix D. Answers to Test Your Thinking Sections.

Appendix E. Oracle 9i SQL New Features.

Index.

Product Details

ISBN:
9780130157430
Other:
Rosenzweig, Benjamin
Author:
Silvestrova, Elena
Author:
Rosenzweig, Benjamin
Author:
Silvestrova, Elena
Publisher:
Prentice Hall PTR
Location:
Upper Saddle River, N.J.
Subject:
Programming Languages - SQL
Subject:
Workbooks
Subject:
Relational databases
Subject:
Database Management - Oracle
Subject:
PL/SQL (Computer program language)
Subject:
Oracle (Computer file)
Subject:
Oracle
Subject:
PL/SQL
Subject:
Query languages
Subject:
Database Management - General
Copyright:
Edition Description:
Trade paper
Series:
Interactive Workbook Series
Series Volume:
no. PR03
Publication Date:
20021029
Binding:
Paperback
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
688
Dimensions:
9.19 x 7 x 1.41 in 1075 gr

Other books you might like

  1. Dying Without God: Francois... Used Hardcover $3.75
  2. The Windows NT and Windows 2000... Used Trade Paper $4.98
  3. Doors Used Hardcover $4.95
  4. Oracle PL/SQL Built-Ins Pocket Reference
    Used Trade Paper $0.50
  5. Encounters with the Archdruid
    Used Trade Paper $6.95

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » SQL

Oracle PL/SQL Interactive Workbook Used Trade Paper
0 stars - 0 reviews
$3.25 In Stock
Product details 688 pages Prentice Hall - English 9780130157430 Reviews:
"Synopsis" by , Master Oracle Pl/SQL fast with this complete book-and-Web hands-on course. The authors cover syntax, iterative control, scoping, cursors, triggers, security, and more. "Test Your Thinking" projects feature hundreds of self-review questions and exercises.
"Synopsis" by , Oracle PL/SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i PL/SQL skills you need, hands-on, through labs, exercises, projects, and a complete Web-based training site! Master syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, packaging, exceptions, cursors, collections, records, and more. Free Web training module includes Virtual Study Lounge: interact with other learners, work on new projects, and get updates.
spacer
spacer
  • back to top

FOLLOW US ON...

       
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.