Complete tutorial for database developers!Thorough coverage of PL/SQLPractical qcookbookq 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 dictionaryComplex rule enforcementPL/SQL program units and language featuresData types and composite structureError handling and exceptionsInter-process communicationsDeclarative 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 databasesReferential integrity can be implemented, to various degrees, across databases. This can be complicated. Options are to use triggers, refreshed materialized views, or Oracle replication. Materialized views are a straightforward and balancedanbsp;...
|Title||:||Programming Oracle Triggers and Stored Procedures|
|Publisher||:||Prentice Hall Professional - 2004|