The goal of this DOAG project is to document common best practises for PL/SQL development.
It is meant to give you something to think about, with links to get more in-depth information about the subject. It is NOT meant to teach you PL/SQL as such. If you are interested in learning PL/SQL from scratch, start here Where to start and here PL/SQL Tutorial and then consider buying this book Oracle PL/SQL Programming by Steven Feuerstein. Experienced PL/SQL developers often like this book for reference purposes: Oracle PL/SQL Language Pocket Reference.
Before learning PL/SQL, you should be familiar with SQL. If you are new to SQL, have a look here: SQL for Web Nerds and experiment with it at Oracle Live SQL
In case you are wondering what the heck we're talking about, have a look here to get an overview of what a database actually is: Oracle for Absolute Beginners
You can request edit access to this repository through GitHub. After approval, you can edit all pages directly in Github with your web browser. Each page is written using the Markdown notation. Have a look here to get acquainted with this notation: Markdown Cheatsheet.
If you are using images in your article, store them in the articles/images folder.
If you like, you can also create a local copy of all files and work with your favourite Markdown-editor like Prose, StackEdit or Dillinger
- General Best practices
- Coding Practises
- Handling Exceptions
- Logging
- Naming Conventions
- Structured Testing
- Code Generators
If you added or completed another page, feel free to add it here.