Programming Oracle
Triggers and Stored Procedures
3rd Edition
Book Details:
| Publisher: | Prentice Hall PTR |
| Series: | Prentice Hall |
| Author: | Kevin Owens |
| Edition: | 3 |
| ISBN-10: | 0130850330 |
| ISBN-13: | 9780130850331 |
| Pages: | 448 |
| Published: | Dec 05 2003 |
| Posted: | Nov 19 2014 |
| Language: | English |
| Book format: | CHM |
| Book size: | 1.22 MB |
Book Description:
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.
Download Link:
Related Books:
Expert Oracle Database Architecture
Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
2nd Edition
Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then youll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the developmentsup toOracle Database 11g. Each fea...
Expert Oracle
9i and 10g Programming Techniques and Solutions
This is a defining book on the Oracle database for any developer ordatabase administratorwho works with Oracle-driven database applications. Tom Kytehas a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including: Files, memory structures and processes Locking and latching Transactions, concurrenc...
Advanced Oracle PL/SQL
Programming with Packages
Steven Feuerstein's first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language.Much more than a book, Advanced Oracle...
2007 - 2021 © eBooks-IT.org