Muutke küpsiste eelistusi

Oracle Pl/SQL: Expert Techniques for Developers and Database Administrators [Multiple-component retail product]

4.00/5 (2 hinnangut Goodreads-ist)
  • Formaat: Multiple-component retail product, 352 pages, kõrgus x laius x paksus: 228x182x27 mm, kaal: 704 g, Illustrations, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 01-Jan-2008
  • Kirjastus: Charles River Media
  • ISBN-10: 1584505540
  • ISBN-13: 9781584505549
Teised raamatud teemal:
  • Multiple-component retail product
  • Hind: 58,59 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Oracle Pl/SQL: Expert Techniques for Developers and Database AdministratorsSuurem pilt
  • Formaat: Multiple-component retail product, 352 pages, kõrgus x laius x paksus: 228x182x27 mm, kaal: 704 g, Illustrations, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 01-Jan-2008
  • Kirjastus: Charles River Media
  • ISBN-10: 1584505540
  • ISBN-13: 9781584505549
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781584505549.html
Märksõnad:
Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. It covers the practical 'how-to' techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards that can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Arvustused

PART I: INTRODUCTORY CONCEPTS Chapter 1: Introduction to PL/SQL Chapter 2: PL/SQL by Dissection Chapter 3: New Features in PL/SQL PART II: TECHNIQUES FOR PL/SQL PROGRAMMING Chapter 4: Data Structure Management in PL/SQL Chapter 5: Error Management in PL/SQL Chapter 6: Data Management in PL/SQL Chapter 7: Application Management in PL/SQL Chapter 8: Transaction Management in PL/SQL PART III: APPLYING PL/SQL IN THE REAL WORLD Chapter 9: Application Development Frameworks Using PL/SQL Chapter 10: Applying PL/SQL in 3GL and Web Environment Chapter 11: Miscellaneous Techniques Chapter 12: PL/SQL Tuning and Debugging Chapter 13: PL/SQL Coding Standards

Introduction xiii
Part I Introductory Concepts
1(50)
Introduction to PL/SQL
3(10)
Why Use PL/SQL?
4(1)
When Not to Use PL/SQL
5(1)
PL/SQL Overview
5(2)
Data Structure Management
6(1)
Error Management
6(1)
Data Management
6(1)
Application Management
6(1)
Transaction Management
7(1)
Using PL/SQL in the Real World
7(4)
Summary
11(2)
PL/SQL by Dissection
13(16)
Program Structure
14(4)
Internal Architecture
18(3)
PL/SQL Compilation
19(2)
PL/SQL Execution
21(4)
Memory Usage
22(2)
Meta Data for PL/SQL Code
24(1)
Program Debugging
25(1)
Protecting Source Code
26(2)
WRAP Utility
26(1)
DBMS_DDL Package
26(2)
Summary
28(1)
New Features in PL/SQL
29(22)
Introduction
29(1)
New Features in Oracle 11g
30(5)
New PLW-06009 Warning When a When Others Clause Does Not Have a Raise or Raise_Application_Error
30(1)
Fine-Grained Dependency Tracking
31(1)
Dynamic SQL Enhancements
31(1)
PL/SQL Triggers Enhancements
31(1)
PL/SQL Intra-Unit Inlining (Efficiency)
32(1)
SQL and PL/SQL Result Caching (Efficiency)
33(1)
Enhanced Native Compilation
34(1)
Other Miscellaneous Enhancements
34(1)
New Features in Oracle 10g
35(14)
An Enhanced DBMS_OUTPUT Package (Oracle 10gR2)
35(1)
Tracking the Error Line Number
35(3)
Compile-Time Warnings
38(1)
Programmer-Defined Quote Delimiter for String Literals
39(1)
Enhanced FORALL Statement for Handling DML Array Processing with Sparse Collections
40(5)
Conditional Compilation (Oracle 10gR2)
45(2)
Nested Table Enhancements
47(1)
Regular Expressions
47(1)
Enhanced Email Facility from PL/SQL
48(1)
New PL/SQL API for Linear Matrix Math (Oracle 10gR2)
49(1)
Summary
49(2)
Part II Techniques for PL/SQL Programming
51(142)
Data Structure Management in PL/SQL
53(38)
Techniques for Using Records
54(6)
Data I/O Using Records
54(2)
Using Functions to Perform Record Comparison
56(4)
Techniques for Using Associative Arrays
60(12)
Performing Data I/O
61(6)
Caching Lookup Data
67(5)
Techniques for Using Nested Tables
72(11)
Passing Resultsets Between PL/SQL Programs
72(5)
Manipulating Stored Nested Tables Using SQL
77(6)
Simulating Multi-Dimensional Arrays
83(6)
Records versus Objects
89(1)
Summary
90(1)
Error Management in PL/SQL
91(18)
Techniques for Obtaining Complete Error Information
93(7)
Tracking the Error Line Number
98(2)
Techniques for Customizing the Error Info Returned
100(8)
Techniques for Halting Further Processing on Error Occurrences
101(3)
Throwing, Trapping, and Handling Customized Errors
104(4)
Summary
108(1)
Data Management in PL/SQL
109(34)
Data-Retrieval Techniques
110(2)
Data-Manipulation Techniques
112(1)
Array Processing in PL/SQL
113(29)
Array Processing Using Static SQL
114(3)
Techniques for Bulk DML
117(15)
Bulk DML with Sparse Collections
132(5)
Techniques for Bulk Querying
137(4)
Array Processing Using Dynamic SQL
141(1)
Summary
142(1)
Application Management in PL/SQL
143(26)
Procedures versus Functions
144(2)
Calling from SQL
144(1)
Creating a Function-Based Index
145(1)
Creating a Table Function
146(1)
Using User-Defined Operators and Functions
146(1)
Coding Packages to Globalize Data and Code
147(2)
Packages versus Contexts and Globalizing Data
149(1)
Coding Packages to Localize Data and Privatize Code
150(1)
Coding Packages to Break the Dependency Chain
150(7)
Reading and Writing Package Variables Dynamically
157(3)
Coding Packages to Pass Data Between Applications
160(4)
Using Cursor Variables
161(1)
Using Collections
161(3)
Packages versus Objects as Application Structures
164(1)
Supplementing Data Integrity Using Triggers
165(2)
Summary
167(2)
Transaction Management in PL/SQL
169(24)
Asynchronous COMMIT
170(1)
Autonomous Transaction Techniques
171(6)
Using Autonomous Transactions for Error Logging
172(4)
Using COMMIT Inside a Database Trigger
176(1)
Techniques for Auditing Queries
177(15)
Summary
192(1)
Part III Applying PL/SQL in the Real World
193(116)
Application Development Frameworks Using PL/SQL
195(36)
Error-Logging Framework
196(9)
Calling Program
203(2)
DML Auditing Framework
205(12)
Calling Program
214(3)
ETL Framework
217(6)
Techniques for Performing ETL Using PL/SQL
217(5)
Case Study--Replacing Staging Tables Using Transformation Pipeline Chain
222(1)
Performance Tuning Framework
223(6)
Framework for Monitoring and Tuning SQL
224(3)
Framework for Monitoring and Tuning PL/SQL
227(2)
Summary
229(2)
Applying PL/SQL in 3GL and Web Environments
231(22)
Extending PL/SQL to Use Java
232(10)
Loading the Java Class (Source or Binary)
233(1)
Publishing the Java Method
234(2)
Calling the Java Method via Its Call Spec
236(1)
Using External Java Methods to Pass Data Between Applications
237(3)
Auto-Generating Call Specs Using loadjava
240(2)
Extending PL/SQL to Use HTML
242(3)
HTML in PL/SQL versus PL/SQL in HTML
245(1)
Emailing Techniques in PL/SQL
246(5)
Emailing from PL/SQL with Large Binary Attachments
246(5)
Using UTL_MAIL versus UTL_SMTP
251(1)
Summary
252(1)
Miscellaneous Techniques
253(30)
Simulating a Dataset Stage Using Pipelined Table Functions
254(9)
Extract Phase
256(1)
Transform Phase
256(4)
Load Phase
260(1)
Replacing Staging Tables Using a Transformation Pipeline Chain
261(2)
Auto-Generating Code Using Dynamic SQL and/or PL/SQL
263(6)
Auto-Generating Static PL/SQL Code
265(1)
Auto-Generating Dynamic PL/SQL Code
266(3)
Hiding Statically Written and Dynamically Generated PL/SQL Code
269(13)
Wrapping the PL/SQL Source File to a PL/SQL Binary File
269(6)
Obfuscating Dynamically Generated PL/SQL Source Code
275(3)
Using the WRAP Utility in Conjunction with DBMS_DDL.CREATE_WRAPPED
278(4)
Summary
282(1)
PL/SQL Tuning and Debugging
283(14)
Tuning Data Structures
284(2)
Tuning Procedural Code
286(6)
Cursor Management
287(1)
Array Processing
288(1)
Use of Dynamic SQL and PL/SQL
289(1)
Coding of Procedures and Functions and Their Modularization (and Encapsulation) into a Package
290(1)
Invoker and Definer Rights
291(1)
Efficient Transaction Management
292(1)
Techniques for Debugging PL/SQL
292(4)
Putting a Robust Error-Handling Mechanism in Place
293(1)
Introducing Debug Messages as Part of the Code Asynchronously
294(2)
Monitoring the Code to Get the Execution Profile
296(1)
Summary
296(1)
PL/SQL Coding Standards
297(12)
Data Structure Management
298(2)
Error Management
300(1)
Data Management
301(3)
Application Management
304(2)
Transaction Management
306(1)
Using PL/SQL in 3GL and the Web
306(1)
Summary
307(2)
Index 309
Lakshman Bulusu is an experienced Oracle Professional with more than 15 years of extensive experience in software management, design, and development using Oracle and its related technologies, including PL/SQL and Java. He's the author of Oracle Developer Forms Techniques and Oracle and Java Development, Oracle9i PL/SQL: A Developer's Guide, and Oracle Programming FAQ. He holds an Oracle Masters credential and an OCP certifi cation from Oracle Corporation, and is a double honors graduate in computer science and engineering and mathematics. He has presented at numerous international and national conferences on Oracle and its tools and published articles in various technical magazines and journals in the United States and the United Kingdom. Currently, as a Technical Manager for Software Development at Genex Technologies, he oversees the management, design, and development of mission-critical Oracle projects for major clients across the U.S., Europe, and Asia.