Items related to Programming Oracle Triggers and Stored Procedures

Programming Oracle Triggers and Stored Procedures - Softcover

 
9780130850331: Programming Oracle Triggers and Stored Procedures

Synopsis

Advanced Oracle features such as triggers and stored procedures make itpossible to build databases that incorporate business rules - allowing companiesto reengineer processes more quickly and effectively than ever. This is the"bible" for anyone designing complex Oracle databases that incorporatebusiness rules, and it is fully compliant with Oracle 10g. The book presents asimple methodology which yields a highly-maintainable repository of triggersand stored procedures which are easy to manage and modify as the businesschanges. Topics covered include: declarative constraints; analyzing constraintsthrough the data dictionary; PL/SQL program units; embedded SQL; datatypes and composite structures; error handling and exceptions; andinterprocess communication.A trigger is a condition, which if true, causes a stored procedure to execute.Stored procedures are SQL code embedded in the database that providescritical information to the end user when triggered.

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

About the Author

KEVIN OWENS is the Oracle database administrator at the U.S. Department of the Treasury in Washington, DC.

From the Back Cover

  • Complete tutorial for database developers!
  • Thorough coverage of PL/SQL
  • Practical "cookbook" techniques

Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business.

Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are easy to manage and modify as the business evolves. Topics covered include:

  • Viewing constraints in the data dictionary
  • Complex rule enforcement
  • PL/SQL program units and language features
  • Data types and composite structure
  • Error handling and exceptions
  • Inter-process communications
  • Declarative constraints, including primary key, unique, foreign key, check, and much more

Programming Oracle Triggers and Stored Procedures, Third Edition, is an invaluable resource for database developers, designers, and project leaders looking to build and maintain truly intelligent, complex databases

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

Buy Used

Condition: Very Good
May have limited writing in cover...
View this item

£ 9.09 shipping from U.S.A. to United Kingdom

Destination, rates & speeds

Search results for Programming Oracle Triggers and Stored Procedures

Stock Image

Owens, Kevin
Published by Prentice Hall PTR, 2003
ISBN 10: 0130850330 ISBN 13: 9780130850331
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.35. Seller Inventory # G0130850330I4N00

Contact seller

Buy Used

£ 8.30
Convert currency
Shipping: £ 9.09
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Owens, Kevin
Published by Prentice Hall PTR, 2003
ISBN 10: 0130850330 ISBN 13: 9780130850331
Used Paperback

Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.35. Seller Inventory # G0130850330I4N00

Contact seller

Buy Used

£ 8.30
Convert currency
Shipping: £ 9.09
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Owens, Kevin
Published by Prentice Hall Ptr, 2003
ISBN 10: 0130850330 ISBN 13: 9780130850331
Used Paperback

Seller: dsmbooks, Liverpool, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. Very Good. book. Seller Inventory # D8S0-3-M-0130850330-6

Contact seller

Buy Used

£ 65.04
Convert currency
Shipping: £ 9
Within United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Owens, Kevin
Published by Prentice Hall Ptr, 2003
ISBN 10: 0130850330 ISBN 13: 9780130850331
Used Paperback

Seller: HPB-Red, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_315560052

Contact seller

Buy Used

£ 5.26
Convert currency
Shipping: £ 85.03
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

OWENS
Published by PEARSON EDUCACION, 2003
ISBN 10: 0130850330 ISBN 13: 9780130850331
Used Softcover

Seller: OM Books, Sevilla, SE, Spain

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: usado - bueno. Seller Inventory # 9780130850331

Contact seller

Buy Used

£ 392.66
Convert currency
Shipping: £ 15.13
From Spain to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket