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
Customer Reviews
4 of 4 people found the following review helpful
A great book . Very helpful PL/SQL, March 12, 2004
By A Customer
This review is from: Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series) (Paperback)
This is an excellent beginner's book for programmers. It begins with an emphasises on the basics of creating tables with declarative constraints. Following this is an easy-to-understand graphical and written description of how to use database triggers to enhance the integrity of the database; then several chapters on PL/SQL. What I liked most about this book is the plain and simple approach to some complex topics. I would recommed this book to any technical person who wants to learn Oracle quickly. I almost didn't buy it because the key word "PL/SQL" is not in the title but it certainly provides nice coverage of PL/SQL, not just the language syntax but an intuitive meaning of the package specification and body.
Help other customers find the most helpful reviews
This review is from: Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series) (Paperback)
This book provides an excellent starting place for the beginning programmer or DBA. There is a ton of information on relational databases & how they relate to Oracle. If you haven't been using Oracle for long then this is an excellent book to have! If you are already experienced in Oracle and looking for a reference book - or an advanced book - this isn't it.
Help other customers find the most helpful reviews
Simplify SQL*Plus for Yourself on Windows. Connecting. Connecting to an Infrastructure. Disconnecting. Command Line. Changes on the Command Line. Scripts. Script Output. Command Line Arguments. SQL*Plus with Korn Shell. Batch Command Files. SQL*Plus with Active State Perl. Privileges. DUAL. Autotrace.
3. Declarative Constraints.
Primary Key. Unique. Foreign Key. Check. Not Null Constraints. Default Values. Modifying Constraints. Exception Handling. Data Loads.
By completing any purchase on InformIT, you become eligible for an unlimited access one-month subscription to Safari Books Online.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
