Hi Dragonia,

Dragonia wrote:

Are there any design patterns specific to oracle apex like MVC (Model - View - Controller ) for Java ?  or Design Best Practices??

     There are no specific design patterns in Oracle APEX as they are in Java, but there are Design Best Practices.

     As far as Oracle APEX application design is concerned you have following points to consider:

• Database Design : Focus on designing the database so that you can make more use of APEX built-in features. Database design patterns and rules, I assume that you know already.
• Business Logic Design : Leverage the tight-coupledness of Oracle APEX with Oracle Database with the help of efficient/optimized SQL and PL/SQL. You will get design patterns for PL/SQL. Try to cover the most business logic in packaged functions/procedures and leave very small foot print of SQL and PL/SQL in APEX components.
• UI Design : It's all about HTML/CSS. You will get loads of information about HTML/CSS design patterns. Follow the UI which fits your requirements and then you can modify the theme templates to design your custom theme in Oracle APEX.

     For Design Best Practices you can refer the following white paper's and presentations:

• http://www.oracle.com/technetwork/testcontent/apex-best-practices-134310.pdf
• http://www.sagecomputing.com.au/papers_presentations/apex2009_best_practice.pdf
• Best Practices for PL/SQL Development in APEX - Oracle - Oracle - Toad World
• PL/SQL: Writing PL/SQL in Oracle Application Express

     NOTE : The best practices links mentioned are dated back to old versions, but most of the practices remain same in Oracle APEX.

     Hope this helps!

Regards,

Kiran

Hi Dragonia,

Dragonia wrote:

Thanks alot Kiran. Is there a link from which i could read about the PLSQL Design Patterns as well ?

     Yes, following is the blog series, I found out done by Lucas Jellema on PL/SQL Design Patterns:

• https://technology.amis.nl/2006/05/30/why-are-there-so-few-resuable-plsql-components-discussion-triggered-by-presentatio…
• https://technology.amis.nl/2006/03/10/design-patterns-in-plsql-the-template-pattern/
• https://technology.amis.nl/2006/04/02/design-patterns-in-plsql-implementing-the-observer-pattern/
• https://technology.amis.nl/2006/03/11/design-patterns-in-plsql-interface-injection-for-even-looser-coupling/

Regards,

Kiran