scientific article; zbMATH DE number 1263045
Urman's book is an actual compendium on PL/SQL of Oracle* and Oracle7. The book explains all the basics of the language and elaborates the new functions of PL/SQL 8.0 especially LOBs and abstract data types. The book is a revised edition of the first one. The revision encloses besides the extended functionality of PL/SQL 8 also clearer structured and illustrated explainaton of the PL/SQL constructs. The edition of the Hanser Verlag is a translation in German. It is a translation from the official, Oracle authorizided book (Oracle Press serie) with the same title, published 1997, Mc Graw Hill. The book is recommended to Oracle application developers especially, beginners and experienced ones. The book's focus is the SQL server's complex functionality; Nevertheless basics are explained, mainly in the chapters 1-4. Each chapter is structured well, any explaination is illustrated by examples and listings. Hints are given highlighted. The book index is rather detailed. The appendix contains usefull overviews: A: PL/SQL reserved terms, B: package descriptions, C: functions of PL/SQL (Glossar) with references to the chapters, D: The Data Dictionary. A CD is added with all examples and two demo versions: WebServer of Oracle and SQL-Station of Platinum. These tools are usable. All together, the book counts 885 pages. The content is structured thema-oriented. There is no special reference list, just the general index. The specialities of Oracle7 are listed at the end of each chapter. The section before it is also repaeted within each chapter, called: Let's tune it. It summarizes the hints for tuning, given through the chapter. The content is as follows: Chapter 1: Introduction in PL/SQL; Chapter 2: The basics of PL/SQL; Chapter 3: Data records and tables; Chapter 4: SQL use in PL/SQL (with GRANT, REVOKE, Transactions); Chapter 5: Integrated SQL functions (characters, numerical values, numerical functions, date, transformation functions, grouping, others); Chapter 6: Cursor; Chapter 7: Subprograms (procedures and functions); Chapter 8: Packages; Chapter 9: Trigger; Chapter 10: Exceptions; Chapter 11: Objects; Chapter 12: Collections; Chapter 13: PL/SQL Run-time environment; Chapter 14: Tests, Faults; Chapter 15: Dynamical PL/SQL; Chapter 16: Communication between sessions; Chapter 17: Oracle Advanced Queueing; Chapter 18: Database-Jobs and File i/o; Chapter 19: Oracle Web Application Server; Chapter 20: External Procedures; Chapter 21: Large Objects; Chapter 22: Performance optimalization.
- Oracle PL/SQL programming. Guide to Oracle8i features. Translated from the English by Wolfgang Gabriel. Incl. 1 disc
- Learning Oracle PL/SQL
- scientific article; zbMATH DE number 1263037 (Why is no real title available?)
- scientific article; zbMATH DE number 1314483 (Why is no real title available?)
- PL/ SQL
- scientific article; zbMATH DE number 1156412 (Why is no real title available?)
- scientific article; zbMATH DE number 1156414 (Why is no real title available?)
- scientific article; zbMATH DE number 1977238 (Why is no real title available?)
- scientific article; zbMATH DE number 1411877 (Why is no real title available?)
This page was built for publication:
Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q4234036)