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:

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.

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

Let’s wreck this together!

Filed under Allgemein Tags:

Leave a Reply



SEO Powered by Platinum SEO from Techblissonline