Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media).
Meer over de auteursOracle PL/SQL Programming
Covers Versions Through Oracle Database 12c
Paperback Engels 2014 6e druk 9781449324452Samenvatting
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.
Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
- Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
- Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
- Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
- Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
- Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers
Specificaties
Lezersrecensies
Over Bill Pribyl
Inhoudsopgave
Part 1: Programming in PL/SQL
1. Introduction to PL/SQL
2. Creating and Running PL/SQL Code
3. Language Fundamentals
Part 2: PL/SQL Program Structure
4. Conditional and Sequential Control
5. Iterative Processing with Loops
6. Exception Handlers
Part 3: PL/SQL Program Data
7. Working with Program Data
8. Strings
9. Numbers
10. Dates and Timestamps
11. Records
12. Collections
13. Miscellaneous Datatypes
Part 4: SQL in PL/SQL
14. DML and Transaction Management
15. Data Retrieval
16. Dynamic SQL and Dynamic PL/SQL
Part 5: PL/SQL Application Consruction
17. Procedures, Functions, and Parameters
18. Packages
19 Triggers
20. Managing PL/SQL Code
21. Optimizing PL/SQL Performance
22. I/O and PL/SQL
Part 6: Advanced PL/SQL Topics
23. Application Security and PL/SQL
24. PL/SQL Architecture
25. Globalization and Localization in PL/SQL
26. Object-Oriented Aspects of PL/SQL
27. Calling Java from PL/SQL
28. External Procedures
A: Regular Expression Metacharacters and Function Parameters
B: Number format Models
C: Data format Models
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan