Programming Oracle Triggers and Stored Procedures

✍ Scribed by Kevin Owens

Publisher: Prentice Hall PTR
Year: 2003
Tongue: English
Leaves: 448
Series: Prentice Hall PTR Oracle Series
Edition: 3
Category: Library

⬇ Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis

Complete tutorial for database developers! * Thorough coverage of PL/SQL * Practical "cookbook" techniquesEffectively 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 moreProgramming 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"

📜 SIMILAR VOLUMES

Programming Oracle Triggers and Stored P

📁 Programming Oracle Triggers and Stored Procedures

✍ Feng Yuan 📂 Library 📅 2003 🏛 Prentice Hall PTR 🌐 English

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 incorporatebusi

Programming Oracle Triggers and Stored P

📁 Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)

✍ Kevin Owens 📂 Library 📅 2003 🏛 Prentice Hall PTR 🌐 English

Code Centric: T-SQL Programming with Sto

📁 Code Centric: T-SQL Programming with Stored Procedures and Triggers

✍ Garth Wells (auth.) 📂 Library 📅 2001 🏛 Apress 🌐 English

<p><p>If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, <i>Code Centric: T-SQL Programming with Stored Procedures and Triggers</i> is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the

Professional SQL Server 2005 CLR Program

📁 Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types

✍ Derek Comingore, Douglas Hinson 📂 Library 📅 2006 🏛 Wrox 🌐 English

Microsoft's Common Language Runtime (CLR) is a series of subroutines that basically make up the foundation of a programming language. This is an integral part of Microsoft's .NET framework which is basically an extension of the operating system to provide additional functionality. And of course to t

Professional SQL Server 2005 CLR Program

📁 Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types

✍ Derek Comingore, Douglas Hinson, 📂 Library 📅 2006 🌐 English

SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and

Professional SQL Server 2005 CLR Program

📁 Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates, and Types

✍ Derek Comingore, Douglas Hinson 📂 Library 📅 2006 🏛 Wrox 🌐 English