Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








Oracle standards tips

Oracle Tips by Burleson Consulting

Oracle Online Systems Development Standards

This document describes a standard development environment for APEX systems.

Overall approach

APEX is a rapid development tool that can be used to quickly create working prototypes during the systems analysis and systems design phase.  Each project consists of an on-site DBA and a systems designer who rapidly develop the data model and design prototypes:

  • Fast End-user Feedback - APEX allows for the daily "Is this what you wanted?" feedback that is critical for ensuring that the design matches the needs of the end-user with a WYSIWIG approach.
  • Self-contained analysis & design - All analysis and design specifications are incorporated directly into APEX, eliminating lost documentation.  A standard button at the bottom-right or every online screen will display all analysis specifications, documentation of the existing system, process logic psuedocode and design documents.
  • Daily Development Cycles - During analysis and design, a daily cycle will be used to created a feedback loop:

1 - Analyst and designer conduct detailed interviews.

2 - DBA creates the Oracle schema structures inside APEX (see standards below).

3 - Designer builds the online screen and report prototypes using the data model from step 2.

Application Standards

Application coding standards will ensure uniformity within the application.

  • Affirmative error checking -  All process logic will check all non-zero Oracle return codes.
  • Standard help key - Complete Help documentation will be implemented with the standard F1 Help key and all online help screens will have context sensitive (mouse-over) descriptions.
  • Fast validation - All HTML screens will use Java for instant field entry validation, before going to the database.
  • Standard screen template - A standard template will be used for all screens, utilizing "re-usable included components, as follows:


  • Reusable "include" HTML - header, toc and footer.htm - A re-usable HTML component

  • Screen ID = A unique screen ID, consisting of the application abbreviation and a hierarchy number (e.g. DSS-1420)

  • Screen Specs - The full analysis and design specification will be accessed by a button in the lower-right corner of every screen.  This important feature names the whole system self-contained, and paperless.

PL/SQL Standards

All procedures will be written in PL/SQL (Stored procedures and packages) and utilize the dbms_shared_pool.keep facility for caching.

Whenever possible  applications should be developed so that the database interaction is accomplished through stored procedures and packages. This optimizes performance and standardizes database application development independent of programming languages.

  • Compiled code - All Non Dynamic PL/SQL may be compiled for better performance

  • Array Processing – Bulk Collects, forall and ref cursor usage for maximum system performance

  • Secure pages - All Secure systems areas will use HTTPS Secure Protocol

Also see:

PL/SQL best practice Standards

PL/SQL Programming Design Standards

PL/SQL code alignment standards

PL/SQL Capitalization Best Practices Standards

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.