{"id":1055,"date":"2014-05-24T14:56:57","date_gmt":"2014-05-24T14:56:57","guid":{"rendered":"http:\/\/aprogrammerwrites.eu\/?p=1055"},"modified":"2025-07-22T06:21:48","modified_gmt":"2025-07-22T06:21:48","slug":"brendans-2-page-oracle-programming-standards","status":"publish","type":"post","link":"http:\/\/aprogrammerwrites.eu\/?p=1055","title":{"rendered":"Brendan&#8217;s 2-Page Oracle Programming Standards"},"content":{"rendered":"<p><strong>[This article was migrated to the author&#8217;s GitHub Pages site <a href=\"https:\/\/brenpatf.github.io\/migrated\/brendans-2-page-oracle-programming-standards\/\" target=\"_blank\">here<\/a> in July 2025]<\/strong><\/p>\n<p>I recently had some discussions on PL\/SQL coding standards centred around some documents I\u2019d come across on the internet, as well as some internal company standards documents.<\/p>\n<p>Here are a couple of extensive company standards documents that have been made public:<\/p>\n<ul>\n<li><a href=\"https:\/\/insum-labs.github.io\/plsql-and-sql-coding-guidelines\/v1.1\/Insum-PLSQL-and-SQL-Coding-Guidelines.pdf\">PL\/SQL &#038; SQL Coding Guidelines (Insum)<\/a><\/li>\n<li><a href=\"https:\/\/trivadis.github.io\/plsql-and-sql-coding-guidelines\/v4.4\/\">PL\/SQL &#038; SQL Coding Guidelines (Trivadis)<\/a><\/li>\n<\/ul>\n<p>And this is another interesting document, by William Robertson, which emphasizes common sense in application of standards:<\/p>\n<ul>\n<li><a href=\"http:\/\/williamrobertson.net\/documents\/plsqlcodingstandards.html\">Naming and Coding Standards for SQL and PL\/SQL<\/a><\/li>\n<\/ul>\n<p>These are all valuable documents, but it was thought that many developers would not read and remain familiar with long documents of this kind, and a 2-page summary standards might be useful. Here is my attempt, as a Word document on Scribd:<\/p>\n<p><a style=\"text-decoration: underline;\" title=\"View Brendan's 2-Page Oracle Programming Standards on Scribd\" href=\"http:\/\/www.scribd.com\/doc\/225918845\/Brendan-s-2-Page-Oracle-Programming-Standards\">Brendan&#8217;s 2-Page Oracle Programming Standards<\/a> by <a style=\"text-decoration: underline;\" title=\"View Brendan Furey's profile on Scribd\" href=\"http:\/\/www.scribd.com\/BrendanP\">Brendan Furey<\/a><\/p>\n<p><iframe loading=\"lazy\" id=\"doc_99448\" class=\"scribd_iframe_embed\" src=\"\/\/www.scribd.com\/embeds\/225918845\/content?start_page=1&amp;view_mode=scroll&amp;access_key=key-TXrd2ZWc5wLpRnoE9TKf&amp;show_recommendations=true\" width=\"100%\" height=\"600\" frameborder=\"0\" scrolling=\"no\" data-auto-height=\"false\" data-aspect-ratio=\"0.7080062794348508\"><\/iframe><br \/>\n<!-- AddThis Button BEGIN --><\/p>\n<div class=\"addthis_toolbox addthis_default_style \">\n<a class=\"addthis_button_facebook_like\" fb:like:layout=\"button_count\"><\/a><br \/>\n<a class=\"addthis_button_tweet\"><\/a><br \/>\n<a class=\"addthis_button_pinterest_pinit\"><\/a><br \/>\n<a class=\"addthis_counter addthis_pill_style\"><\/a>\n<\/div>\n<p><script type=\"text\/javascript\">var addthis_config = {\"data_track_addressbar\":true};<\/script><br \/>\n<script type=\"text\/javascript\" src=\"\/\/s7.addthis.com\/js\/300\/addthis_widget.js#pubid=ra-50fd09b73778290b\"><\/script><br \/>\n<!-- AddThis Button END --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[This article was migrated to the author&#8217;s GitHub Pages site here in July 2025] I recently had some discussions on PL\/SQL coding standards centred around some documents I\u2019d come across on the internet, as well as some internal company standards &hellip; <a href=\"http:\/\/aprogrammerwrites.eu\/?p=1055\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[6,26,85,61],"tags":[86,23,62,3,96],"class_list":["post-1055","post","type-post","status-publish","format-standard","hentry","category-oracle","category-performance","category-sql","category-standards","tag-oracle","tag-plsql","tag-programming","tag-sql","tag-standards"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4FdtN-h1","_links":{"self":[{"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/posts\/1055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1055"}],"version-history":[{"count":18,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/posts\/1055\/revisions"}],"predecessor-version":[{"id":3243,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=\/wp\/v2\/posts\/1055\/revisions\/3243"}],"wp:attachment":[{"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1055"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/aprogrammerwrites.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}