Oracle Embedded Programming and Application Development / Edition 1

Hardcover (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $79.71
Usually ships in 1-2 business days
(Save 16%)
Other sellers (Hardcover)
  • All (7) from $79.71   
  • New (5) from $79.71   
  • Used (2) from $94.94   


Focusing on tried and true best practice techniques in cross-technology based Oracle embedded programming, this book provides authoritative guidance for improving your code compilation and execution. Geared towards IT professionals developing Oracle-based Web-enabled applications in PL/SQL, Java, C, C++, .NET, Perl, and PHP, it covers application development from concepts to customization, following a pragmatic approach to design, coding, testing, deployment, and customization—explaining how to maximize embedded programming practices.

Oracle Embedded Programming and Application Development explains application development frameworks using 3GL and 4GL high-level language code as embedded code segments across .NET, Java, and Open Source technologies, in conjunction with SQL and/or PL/SQL and the Oracle RDBMS through version 11gR2. It also:

  • Features pluggable code using parameterized constructs to promote code reuse
  • Explains when to use a particular embedded language as a best fit for specific applications
  • Highlights design considerations that reduce the probability of errors, enable quick resolution, and boost performance in terms of enabling a Fast-Actionable-Synchronized-Tested (FAST) solution implementation
  • Provides best practice techniques that can enhance any application development code-design methodology for a better, easier, faster, cheaper, and pervasive solution that in turn helps achieve a Better Business Benefit (B-B-B)

This practical guide details techniques for constructing architecture and code design methodologies for live application development projects that can be generalized and standardized as application development and code design frameworks. Cover to cover, the text provides an understanding of how the designed, developed, and deployed solutions conform to emerging and next-generation trends. It also discusses the conformance and usage of Web 2.0-based RIA functionality and regulatory compliance practices involving auditing and security.

Praise for:

"Taking an Oracle-centric approach, Lakshman skillfully guides you through the maze of various popular programming languages and environments including .NET, C/C++, Perl, PHP, Java, and even SQL and PL/SQL – not only showing you how they interact with Oracle but also which language is the best fit for a given situation."
—John Kanagaraj, Executive Editor, IOUG SELECT Journal

Read More Show Less

Editorial Reviews

From the Publisher
Taking an Oracle-centric approach, Lakshman skillfully guides you through the maze of various popular programming languages and environments including .NET, C/C++, Perl, PHP, Java, and even SQL and PL/SQL – not only showing you how they interact with Oracle but also which language is the best fit for a given situation.
—John Kanagaraj, Executive Editor, IOUG SELECT Journal
Read More Show Less

Product Details

  • ISBN-13: 9781439816448
  • Publisher: Taylor & Francis
  • Publication date: 9/8/2010
  • Edition number: 1
  • Pages: 372

Meet the Author

Lakshman Bulusu has more than 16 years of experience in the management, supervision, mentoring, review, design and development of Oracle Database, Data Warehousing Business Intelligence , and application development related projects. He is well versed in the primary Oracle technologies through Oracle11g using SQL and PL/SQL; Oracle-related embedded programming, including design and development of Web applications, that are PL/SQL based, .NET based, Java based, Open source based (using Perl, PHP and AJAX) and C, C++ based; Oracle tools like Oracle SQL Developer Data Modeler, Oracle Designer, Oracle Developer Suite, Oracle Warehouse Builder, ODI, etc. His design of Application Development Frameworks using PL/SQL, from design and coding to testing, debugging, and performance tuning has been implemented for Fortune 500 clients in the US.

Read More Show Less

Table of Contents



About the Author


What This Book Covers

Who is This Book For?

Why a Separate Book?

Chapter 1 Embedded Programming An Oracle-Centric Approach 1

1.1 Embedded Programming from an Oracle Perspective: The Primary Indicators and the Solution Life Cycle 2

1.2 What's In and What's Not: Programming Languages, Platforms, and Solution Options Available for an Oracle-Based Solution 3

1.2.1 Using .NET-Based Languages 5

1.2.2 Using Java-Based Languages (Java Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures) 6

1.2.3 Using PHP-Based Languages (PHP-only, PHP and Ajax, PHP Web Pages) 9

1.2.4 The Foundations: Architecture, Technologies, and Methodologies for Integration and Interaction with Oracle 11

1.3 Oracle Database-Specific Code versus Non-Oracle 3GL and 4GL code in Conjunction with SQL and PL/SQL: Key Differentiators 15

1.3.1 Data Processing Differentiators 16

1.3.2 Data Sharing Differentiators 17

1.3.3 Code Manageability Differentiators 18

1.3.4 Error Handling Differentiators 19

1.3.5 Other Key Differentiators 19

Chapter 2 Feature-Set and Solution-Set Enhancements 23

2.1 Introduction 23

2.2 New Feature and Solution Options in Oracle11g 23

2.2.1 SQL/PL/SQL 23

2.2.2 New Functionalities That Benefit the Enterprise Grid 31

2.2.3 PHP/Ajax 32

2.2.4 Oracle, .NET and C# 33

2.2.5 Java 34

2.2.6 XML 35

2.3 New Feature and Solution Options in Oracle10g 35

2.3.1 Regular Expressions 35


2.3.3 Tracking the Error Line Number 36

2.3.4 Enhanced FORALL Statement for Handling DML Array Processing with Sparse Collections 39

2.3.5 Conditional Compilation (Oracle 1OGR2) 40

2.3.6 Compile-Time Warnings 41

2.3.7 Integrated mod_plsql 42

Chapter 3 Programming Languages, Platforms, and Solutions 43

3.1 Introduction 43

3.2 Why and When Architecture Takes Precedence over Feature Set 44

3.2.1 Suitability Criteria from a Business/Customer Perspective 49

3.2.2 Suitability Criteria from a Solution Architecture (Technical/Techno-Functional) Perspective 50

3.3 Best Practices in Terms of Oracle Database Interaction 53

3.3.1 Enforcing Business Rules for Efficiency 56

3.3.2 Pre-emptive and Proactive Measures 57

3.3.3 Database Interaction: More than Just GB and Data Quality 58

3.4 Best Practices for using SQL and PUSQL only (with HTML, XML via PSP or Web Toolkit) 59

3.5 Extending PUSQL to Use Emerging Dynamic Scripting Languages Like Groovy in the Database 61

3.5.1 Extending PUSQL to Use HTMUXML 61

3.5.2 Generating Web-Enabled PUSQL Applications Using Oracle APEX/Oracle JDeveloper 65

3.6 Best Practices for Using .NET-Based Languages (C++, C#, J#) 66

3.6.1 ODP.NET: More than Just ADO.NET Rehashed 66

3.6.2 Leverage J2EE Inherent Server-Specific Benefits with Minimal Cost and Time-to-Deliver 67

3.7 Best Practices for Using Java-Based Languages aava Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures) 69

3.7.1 Using Java via JDBC, SQLJ, Java Stored Procedures or Java Libraries 73

3.8 Best Practices for Using PHP-Based Languages (PHP-only, PHP and Ajax, PHP Web Pages) 75

3.9 Perl in the Picture: Best Practices for the Perfect Fit and Use of Peri in an Embedded Scenario 77

3.10 For Better or Worse: Application-centric and Business-centric Key Performance Indicators 78

3.10.1 Focus on the Customer 78

3.10.2 Application-Centric 79

Chapter 4 Best Practices for Data Structure Management 83

4.1 Introduction 83

4.2 Data Representation: Database versus Programming Language Perspectives 85

4.2.1 Database Implementation 93

4.2.2 Programming Language Implementation 94

4.3 Best Practices for Using Heterogeneous Data Structures: Arrays, Array Lists, Lists, Maps, Enumerations 95

4.3.1 Design of a Code Accelerator that Uses Optimized Data Structures for Efficient Data as Well as Data Structure Management 98

4.4 Best Practices for Using LINQ to Objects (in Oracle11g) 100

4.4.1 How does LINQ fit in the Oracle11g-.NET space? 101

4.4.2 Best Uses of ODP.NET LINQ to Objects in Oracle11g 103

4.5 Best Practices for Using Objects as Data Structures 104

4.5.1 Code Accelerator for the Consolidation of Data based on Type Granularity 105

4.6 Best Practices for Metaprogramming: Use or Eliminate 107

Chapter 5 Best Practices for Robust Error Detection and Handling Management 111

5.1 Introduction 111

5.2 Best Design Practices to Reduce the Probability of Errors and Enable Quick Resolution 113

5.2.1 Design Pattern for a Typical Error-Handling Code Accelerator 118

5.2.2 Best Practices in Terms of Tracking and Trapping Errors 122

5.3 Techniques to Obtain Complete Error Information 128

5.3.1 Tracking Error Information for Database Errors (Occurring in Any Tier) 130

5.4 Techniques to Customize the Error Information Returned 131

5.4.1 Database Errors 131

5.4.2 Programming Language Specific Errors (Not Related to Oracle Server Errors) 132

5.5 Techniques for Halting Further Processing on Error Occurrences 133

Chapter 6 Best Practices for Data Management 135

6.1 Introduction 135

6.2 Database Management Using Embedded Programming Languages: Design Practices for the Best Degree of Fit 140

6.3 Best Practices in Terms of Connectivity to and Interaction with the Oracle Database 144

6.4 Techniques to Connect to Multiple Databases Simultaneously Using the Same Metadata 148

6.5 Best Fit for Oracle in the ADO.NET Framework-ODP.NET and ODE.NET 150

6.6 Best Practices for Data Retrieval 150

6.7 Best Practices for Data Manipulation 153

6.8 Best Practices for Data Validation 155

6.9 Best Practices for using LINQ to SQL 158

6.10 Best Practices for Using XML 158

6.11 Best Practices for Handling Unstructured Data 162

6.12 Best Practices to Protect Data Integrity and Special Cases Involved 165

6.12.1 User Interaction with Data (and hence with the Database) 166

6.12.2 Special Cases Involved 171

6.12.3 Application Interaction with Data (and hence with the Database) 171

6.12.4 Design Pattern for a Typical Code Accelerator 176

Chapter 7 Best Practices for Application Management 181

7.1 Introduction 181

7.2 Code Accelerators for Rapid Application Development: Design and Coding Aspects 183

7.2.1 Code Accelerator Design Pragmatics 187

7.3 Best Practices for Application Web Interaction: Receiving, Routing, Responding, Redirecting, Rendering, Linking 196

7.3.1 Personalized A-La-Carte of Customer/End-User Service Requests: A Real-World Use Case of Application Web Interaction 199

7.4 Best Practices for Application Integrity 200

7.4.1 A Design Pattern for a Common Information Integrity Framework at the End-to-End Solution Level 201

7.5 Best Practices for Application Consistency 204

7.5.1 Multitenancy of Data Services Calls, Web Services Calls, and Java Services Calls 205

7.5.2 A Real-World Scenario that Demonstrates the Use of These Best Practices for Implementation 208

7.6 Best Practices for Security Beyond User Authentication: End-to-End Application Security 209

7.6.1 Real-World Use Cases for Implementing Web Security Policies 214

7.7 Best Fit for Oracle in the ASP.NET Framework 216

7.8 Best Practices for Templates: Use or Eliminate? 220

7.9 Best Practices Beyond HTML: Auto-generate Dynamic Visual Content, Web Services, and Mobile Applications 221

7.9.1 Auto-generate Dynamic Visual Content 221

7.9.2 Web Services 225

7.9.3 Mobilizing Applications 226

7.10 Best Practices for Creative Reporting 227

Chapter 8 Application Development Frameworks 237

8.1 Introduction 237

8.2 Application Development Framework: A Pragmatic "Best-Possible" Solution 238

8.2.1 For a Transactional Solution 240

8.2.2 For a Reporting and Analysis Solution 243

8.3 Master Error Management Framework 251

8.3.1 Error-Logging Framework 251

8.3.2 DML Auditing Framework 261

8.4 Performance Tuning Framework 273

8.4.1 Framework for Monitoring and Tuning SQL 274

8.4.2 Framework for Monitoring and Tuning PL/SQL 277

8.5 Debugging Framework 280

8.5.1 Putting a Robust Error-Handling Mechanism in Place 281

8.5.2 Introducing Debug Messages as Part of Code Asynchronously 281

8.5.3 Testing of the Application Solution 294

Chapter 9 Miscellaneous Best Practices 297

9.1 Simulating Oracle-Based Datasets: Best Practices for Design and Coding 297

9.1.1 The In-Memory Processing Framework 298

9.1.2 Simulating Oracle-Based Data Sets Using Transformation Pipeline Chain 302

9.2 Building a Highly Visible Web Site 307

Chapter 10 Best Practices in Terms of Coding Standards and Troubleshooting 315

10.1 Introduction 315

10.2 Coding Standards from an Oracle11g Embedded Programming Perspective 316

10.3 Tuning SQL and PL/SQL Code for Optimality 321

10.4 Tuning Embedded Language Code for Optimality: Data Structures and Procedural Code 330

10.5 Fine-Tuning Solution Methodology for Optimality 333

Index 339

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)