ABSTRACT

Coding standards from an Oracle11g embedded programming perspective

Tuning SQL & PL/SQL code for optimality

Tuning embedded language code for optimality: data structures and procedural code

Fine-tuning solution methodology for optimality

Every application solution makes use of data and its management in one way or the other-data that is persistent, intermittent, and/or consistent in terms of existence, accuracy, and accessibility. The business case for adoption of an Oracle-based embedded programming language solution gains strength if the solution being delivered is based on accelerated and accurate analytics that provide business agility, flexibility, visibility, continuity, and operational efficiency. To implement such a solution, the underlying solution architecture as well as the code design and intrasolution process orchestration must perform optimally from code execution to communication to collaboration to customization, including the customer/end-user interaction and experience.