libcats.org
Главная

Programming Oracle Triggers and Stored Procedures

Обложка книги Programming Oracle Triggers and Stored Procedures

Programming Oracle Triggers and Stored Procedures

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.
Популярные книги за неделю:

Ключ к сверхсознанию

Автор:
Категория: Путь к себе
Размер книги: 309 Kb

Древо жизни

Автор:
Категория: Путь к себе
Размер книги: 1.70 Mb

Здоровье надо созидать

Автор:
Категория: Здоровье
Размер книги: 363 Kb
Только что пользователи скачали эти книги:

Molecular Quantum Mechanics

Автор: , Автор:
Размер книги: 36.11 Mb

Complex Analysis, Third Edition (Undergraduate Texts in Mathematics)

Автор: , Автор:
Категория: Математика
Размер книги: 1.80 Mb

Elements of Number Theory (Undergraduate Texts in Mathematics)

Автор:
Категория: Математика
Размер книги: 1.49 Mb

Three Steps to Chess Mastery

Автор:
Размер книги: 4.74 Mb

Silicon Psalm

Автор:
Категория: fiction
Размер книги: 130 Kb