Building Intelligent Databases with Oracle PL/SQL, Triggers, and Stored Procedures

Be the first to write a review

Overview

The end-to-end resource for anyone who builds business rules-based Oracle database applications.

  • Thorough coverage of PL/SQL, Oracle's version of SQL.
  • Practical, "cookbook" techniques for using triggers, stored procedures, and other advanced Oracle features. Comprehensive troubleshooting and debugging techniques.
  • CD-ROM includes the complete source code library from the book. Data types, composite structures,...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Other Format)
  • All (12) from $1.99   
  • New (1) from $105.0   
  • Used (11) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$105.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

The end-to-end resource for anyone who builds business rules-based Oracle database applications.

  • Thorough coverage of PL/SQL, Oracle's version of SQL.
  • Practical, "cookbook" techniques for using triggers, stored procedures, and other advanced Oracle features. Comprehensive troubleshooting and debugging techniques.
  • CD-ROM includes the complete source code library from the book. Data types, composite structures, error handling, exceptions, and more.
Advanced Oracle features such as triggers and stored procedures make it possible to build databases that incorporate business rules - allowing companies to reengineer processes more quickly and effectively than ever. This is the "bible" for anyone designing complex Oracle databases that incorporate business rules. It presents a simple methodology which yields a highly-maintainable repository of triggers and stored procedures which are easy to manage and modify as the business changes. Topics covered include: declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; embedded SQL; data types and composite structures; error handling and exceptions; and interprocess communication. If you are an Oracle database developer working with Business Rules - or planning to - you'll find this book invaluable.

KEVIN T. OWEN is an Oracle database consultant based in the Washington, DC area.

Read More Show Less

Editorial Reviews

Booknews
Introduces the programming techniques and software engineering methods needed to build powerful, reusable enterprise software components. Coverage includes the fundamentals of PL/SQL; rules-based development; data types and composite structures; important types of database triggers and packages; how to combine and partition software; Oracle interprocess communication, error handling, exceptions, embedded SQL, SQL Plus scriptwriting; and advanced features such as stored procedures. Annotation c. by Book News, Inc., Portland, Or.
Read More Show Less

Product Details

  • ISBN-13: 9780137943142
  • Publisher: Prentice Hall Professional Technical Reference
  • Publication date: 12/10/1997
  • Series: Prentice Hall Oracle Series
  • Edition description: Older Edition
  • Edition number: 2
  • Pages: 560
  • Product dimensions: 7.02 (w) x 9.24 (h) x 1.62 (d)

Table of Contents

Preface ..... xv

1 Introduction ..... 1

1.1 The Logical and Physical View of Tables ..... 1
1.2 Database Types ..... 4
1.3 NULLs ..... 6
1.4 DDL and DML Statements ..... 7
1.5 Column and Table Constraint Clauses ..... 7
1.6 Sample Database ..... 9

2 A Quick Tour of SQL*Plus ..... 17

2.1 What SQL*Plus? ..... 17
2.2 Invoking SQL*Plus ..... 19
2.3 Connecting with SQL*Plus ..... 20
2.4 SQL*Plus Editing/Basic Commands ..... 23
2.5 SQL*Plus Scripts ..... 27
2.5.1 Position-Dependent Parameters ..... 31
2.5.2 Named Parameter Substitution ..... 32
2.5.3 Running Script from a Host User ..... 34
2.6 Select Statements ..... 36
2.6.1 Qualifying Columns ..... 36
2.6.2 Qualifying Rows ..... 38
2.6.3 Joins ..... 39
2.6.4 Table Joins with Nulls ..... 40
2.6.5 Full Outer Join ..... 43
2.6.6 SQL Tutorial ..... 43
2.6.7 Tutorial Solutions ..... 50

3 Declarative Constraints ..... 55

3.1 Introduction ..... 55
3.2 Primary Key ..... 56
3.2.1 Primary Key Versus Unique ..... 58
3.2.2 Concatenated Primary Key ..... 59
3.2.3 Declaring an Additional Not Null Constraint ..... 61
3.2.4 Error Messages ..... 62
3.2.5 Naming Primary Keys ..... 62
3.2.6 PL/SQL Coding with a Primary Key ..... 64
3.2.7 SQL*Loader--Direct Load ..... 71
3.3 Unique Constraints ..... 72
3.3.1 Concatenated UNIQUE Constraints ..... 73
3.3.2 PL/SQL Coding with a UNIQUE Constraint ..... 74
3.4 Not Null Constraints ..... 75
3.4.1 Error Messages ..... 77
3.4.2 Naming Not Null Constraints ..... 77
3.4.3 PL/SQLCoding with Not Null Constraints ..... 77
3.5 CHECK Constraints ..... 82
3.5.1 Multiple Constraints ..... 82
3.5.2 Case Sensitivity ..... 82
3.5.3 Multicolumn Constraints ..... 83
3.5.4 Error Messages ..... 84
3.5.5 Boolean Types as a Check Constraint ..... 85
3.5.6 Complex Check Constraints ..... 85
3.6 Foreign Key Constraints ..... 86
3.6.1 NULLs in the Child Table ..... 89
3.6.2 Delete Cascade ..... 91
3.6.3 Syntax ..... 92
3.6.4 Concatenated Primary Key Is a Foreign Key ..... 93
3.6.5 Lookup Tables ..... 93
3.6.6 Delete Cascade ..... 96
3.6.7 Converting Check Constraints to Lookup Tables ..... 96
3.6.8 Self-referential Integrity ..... 96
3.7 Managing Constraints ..... 102
3.7.1 Introduction ..... 102
3.7.2 Declaring Constraints Disabled ..... 103
3.7.3 Database Table Column Defaults ..... 103
3.7.4 Multiconstraint Columns ..... 104
3.7.5 The Alter Table Command ..... 104
3.7.6 Altering Status ..... 106
3.7.7 Altering Scale and Dimension ..... 106
3.7.8 Altering Status with Cascade ..... 106
3.7.9 Dropping Constraints ..... 107
3.8 Relationships ..... 107
3.8.1 One-to-One Relationship ..... 107
3.8.2 One-to-Many Relationships ..... 108
3.8.3 Many-to-Many Relationships ..... 109

4 Analyzing Constraints through the Data Dictionary ..... 111

4.1 Introduction ..... 111
4.2 User Constraint Columns ..... 115
4.2.1 Show Constraints ..... 116
4.2.2 Show Columns ..... 117
4.2.3 Show Positions ..... 117
4.3 User Constraints ..... 119
4.3.1 Show Table Constraints ..... 121
4.3.2 Show Search Condition ..... 122
4.3.3 Show Parent ..... 123
4.3.4 Show Parent All ..... 124
4.3.5 Show Child ..... 126
4.3.6 Show Child All ..... 127
4.3.7 Show Disabled Constraints ..... 129
4.3.8 Case Study ..... 130
4.4 Summary ..... 133

5 PL/SQL Program Units ..... 135

5.1 Introduction ..... 135
5.2 Procedures ..... 140
5.3 Functions ..... 143
5.4 Packages ..... 146
5.4.1 The Specification ..... 148
5.4.2 Modularity ..... 151
5.4.3 Information Hiding ..... 153
5.4.4 Encapsulation of Types and Operations ..... 157
5.4.5 Data Abstraction ..... 159
5.4.6 Users of Abs
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)