1. An Introduction to Relational Database Tables -- 2. Interacting with Oracle -- 3. Declarative Constraints -- 4. A Data Model with Constraints -- 5. Viewing Constraints in the Data Dictionary -- 6. Row Trigger Mechanics -- 7. Statement Level Triggers -- 8. Complex Rule Enforcement -- 9. The PL/SQL Environment -- 10. PL/SQL Program Units -- 11. PL/SQL Language Features.
بدون عنوان
0
یادداشتهای مربوط به خلاصه یا چکیده
متن يادداشت
Complete tutorial for database developers! Thorough coverage of PL/SQL Practical "cookbook" 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 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.
ویراست دیگر از اثر در قالب دیگر رسانه
شماره استاندارد بين المللي کتاب و موسيقي
0130850330
عنوان به منزله موضوع
موضوع مستند نشده
Oracle (Computer file)
موضوع مستند نشده
Oracle (Computer file)
موضوع (اسم عام یاعبارت اسمی عام)
موضوع مستند نشده
Computer software-- Development.
موضوع مستند نشده
Relational databases.
موضوع مستند نشده
Computer Science.
موضوع مستند نشده
Computer software-- Development.
موضوع مستند نشده
Engineering & Applied Sciences.
موضوع مستند نشده
Relational databases.
رده بندی ديویی
شماره
005
.
75/85
ويراست
22
رده بندی کنگره
شماره رده
QA76
.
9
.
D3
نشانه اثر
O97
2004
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )