Comments:
*******************************************************************************<br />
Oracle PL/SQL by Example <br />
*******************************************************************************<br />
<br />
-------------------------------------------------------------------------------<br />
General Information<br />
-------------------------------------------------------------------------------<br />
Type.................: Ebook<br />
Part Size............: 3,188,838 bytes<br />
<br />
-------------------------------------------------------------------------------<br />
Post Information<br />
-------------------------------------------------------------------------------<br />
Posted by............: ~tqw~<br />
<br />
-------------------------------------------------------------------------------<br />
Release Notes<br />
-------------------------------------------------------------------------------<br />
Start developing applications with Oracle PL/SQL-fast! This integrated book-and<br />
-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, <br />
through real-world labs, extensive examples, exercises, projects, and a complete <br />
Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle <br />
10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional <br />
control, scoping, anchored datatypes, cursors, triggers, security, tables, <br />
procedures, functions, packages and Oracle-supplied packages-plus powerful new <br />
techniques for working with exceptions, cursors, collections, and records. Your <br />
free Web-based training module includes a Virtual Study Lounge where you can <br />
interact with other learners, work on new projects, and get updates!<br />
<br />
Table Of Contents<br />
<br />
Acknowledgments xiv<br />
About the Authors xv<br />
Introduction xvii<br />
CHAPTER 1 PL/SQL Concepts 1<br />
CHAPTER 2 General Programming Language Fundamentals 2<br />
CHAPTER 3 SQL in PL/SQL 39<br />
CHAPTER 4 Conditional Control: IF Statements 53<br />
CHAPTER 5 Conditional Control: CASE Statements 81<br />
CHAPTER 6 Iterative Control: Part I 113<br />
CHAPTER 7 Iterative Control: Part II 143<br />
CHAPTER 8 Error Handling and Built-in Exceptions 163<br />
CHAPTER 10 Exceptions: Advanced Concepts 211<br />
CHAPTER 11 Introduction to Cursors 229<br />
CHAPTER 12 Advanced Cursors 253<br />
CHAPTER 13 Triggers<br />
CHAPTER 14 Compound Triggers 291<br />
CHAPTER 15 Collections 315<br />
CHAPTER 16 Records 349<br />
CHAPTER 17 Native Dynamic SQL 379<br />
CHAPTER 18 Bulk SQL 403<br />
CHAPTER 19 Procedures 439<br />
CHAPTER 20 Functions 449<br />
CHAPTER 21 Packages 457<br />
CHAPTER 22 Stored Code 495<br />
CHAPTER 23 Object Types in Oracle 513<br />
CHAPTER 24 Oracle Supplied Packages 555<br />
APPENDIX A PL/SQL Formatting Guide 597<br />
APPENDIX B Student Database Schema 601<br />
APPENDIX C ANSI SQL Standards 607<br />
APPENDIX D Answers to the Try It Yourself Sections 613<br />
INDEX 705<br />
<br />
Product Details<br />
<br />
* ISBN: 0137144229<br />
* ISBN-13: 9780137144228<br />
* Format: Paperback, 768pp<br />
* Publisher: Prentice Hall<br />
* Pub. Date: September 2008<br />
* Edition Number: 4<br />
<br />
-------------------------------------------------------------------------------<br />
Install Notes<br />
-------------------------------------------------------------------------------<br />
PDF Reader
Add comment