Compact set of general PL/SQL conventions.

Written on April 19th, 2016 by Niels

What would you tell a junior developer about PL/SQL best practises if you only had 60 seconds? Not that easy, right? I will give it a try by creating a Top 5 list:

1. Solve your problem in this order: SQL first, then PL/SQL, then Java, then C.
2. Avoid context switches between SQL and PL/SQL
3. Use bind variables in SQL
4. Use bulk operations
5. Avoid triggers

More info here: https://github.com/Doag/DOAG-PL-SQL-Coding-Conventions/blob/master/articles/00_general.md

Do you also have best practises around PL/SQL development? Now is your time to share it with us! We, the DOAG community, are trying to get 10-20 pages in place on GitHub that will give you a general basic overview of all that matters most around best practises for PL/SQL development.

https://github.com/Doag/DOAG-PL-SQL-Coding-Conventions

We are also working on something similar around APEX, so if you are into APEX, please contribute here:

https://github.com/Doag/DOAG-APEX-Conventions

Let’s wreck this together!

Share
Filed under Allgemein Tags:

Leave a Reply

(erforderlich)

(erforderlich)


SEO Powered by Platinum SEO from Techblissonline