Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20
,

Oracle PL/SQL Programming

Covers Versions Through Oracle Database 12c

Paperback Engels 2014 6e druk 9781449324452
Verwachte levertijd ongeveer 16 werkdagen

Samenvatting

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

ISBN13:9781449324452
Taal:Engels
Bindwijze:paperback
Aantal pagina's:1340
Uitgever:O'Reilly
Druk:6
Verschijningsdatum:20-1-2014
Hoofdrubriek:IT-management / ICT
ISSN:

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Over Steven Feuerstein

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). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online technical cyberhome is located at www.ToadWorld.com/SF. You can also catch up on his latest, mostly non-PLSQL rants at http://feuerthoughts.blogspot.com.

Andere boeken door Steven Feuerstein

Over Bill Pribyl

Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.

Andere boeken door Bill Pribyl

Inhoudsopgave

Preface

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

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Oracle PL/SQL Programming