Boosting location-based services with a moving object database engine
MobiDE '06 Proceedings of the 5th ACM international workshop on Data engineering for wireless and mobile access
| Hi-index | 0.00 |
The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language. Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery. NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk. Oracle PL/SQL Programming is divided into seven parts: Foreword Preface Part I: Programming in PL/SQL 1. Introduction to PL/SQL2. PL/SQL Language Fundamentals3. Effective Coding Style4. Variables and Program Data5. Conditional and Sequential Control6. Database Interaction and Cursors7. Loops8. Exception Handlers9. Records in PL/SQL10.PL/SQL Tables11. Character Functions12. Date Functions13. Numeric, LOB, and Miscellaneous Functions14. Conversion Functions15. Procedures and Functions16. Packages17. Calling Stored PL/SQL Functions from SQL18. Object Types19. Nested Tables and VARRAYs20. Object Views21. External Procedures22. Code Design Tips23. Managing Code in the Database24. Debugging PL/SQL25. Tracing PL/SQL26. Tuning PL/SQLA. What's on the Companion Disk?B. Calling Stored Procedures from PL/SQL Version 1.1C. Built-in Packages Part II: PL/SQL Language Elements Part III: Built-in Functions and Packages Part IV: Modular Code Part V: PL/SQL Oracle8 Features Part VI: Making PL/SQL Programs Work Part VII: Appendixes