{"id":10477,"date":"2020-08-28T15:53:57","date_gmt":"2020-08-28T13:53:57","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=10477"},"modified":"2023-11-12T13:51:52","modified_gmt":"2023-11-12T12:51:52","slug":"formatting-sql-code-blocks-in-markdown-files","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/","title":{"rendered":"Formatting SQL Code Blocks in Markdown Files"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

Everything Changes. Our Trivadis SQL & PL\/SQL Coding Guidelines<\/a> are no exceptions. We plan to change rule #1 of our coding styles<\/a>. From “Keywords are written uppercase, names are written in lowercase.”<\/em>  to “Keywords and names are written in lowercase.<\/em>“. We have 103 Markdown files and most of them contain several SQL code blocks complying to our current (old) rule #1. Should we change these files manually? Nah, this is boring and error-prone. It’s a perfect case to automate it and to show how you can format SQL code blocks in Markdown with SQLcl.<\/p>\n\n\n\n

Tools<\/h2>\n\n\n\n

For this task, we use SQLcl 20.2.0<\/a>. If you work with Oracle databases, you have most likely already installed it.<\/p>\n\n\n\n

SQLcl is basically SQL*Plus<\/a> on steroids. One of the most underestimated features of SQLcl is the ability to execute JavaScript and provide them as custom SQLcl commands (read Erik van Roon<\/a>‘s excellent blog post<\/a> to learn more about it). We use the custom command tvdformat<\/a>. To install it, save format.js<\/a> locally in a folder of your choice. Then start SQLcl (no connection required), go to the folder where you’ve saved format.js<\/code> and run script format.js -r<\/code>. This will register the command tvdformat<\/code>. You get the usage help, when you enter the command without arguments.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Formatting a Single Markdown File<\/h2>\n\n\n\n

Let’s create a simple Markdown file to see how the formatter behaves.<\/p>\n\n\n\n

example.md (unformatted)<\/span><\/path><\/path><\/svg><\/span>
## SQL to be formated<\/span><\/span>\n<\/span>\n``` sql<\/span><\/span>\nSELECT<\/span> * <\/span>FROM<\/span> EMP <\/span>JOIN<\/span> DEPT <\/span>ON<\/span> EMP.DEPTNO = DEPT.DEPTNO;<\/span><\/span>\n```<\/span><\/span>\n<\/span>\n## SQL to be ignored<\/span><\/span>\n<\/span>\n```<\/span><\/span>\nSELECT * FROM EMP JOIN DEPT ON EMP.DEPTNO = DEPT.DEPTNO;<\/span><\/span>\n```<\/span><\/span>\n<\/span>\n## JavaScript to be ignored<\/span><\/span>\n<\/span>\n``` js<\/span><\/span>\nvar<\/span> <\/span>foo<\/span> = <\/span>function<\/span> (<\/span>bar<\/span>) {<\/span><\/span>\n  <\/span>return<\/span> <\/span>bar<\/span>++;<\/span><\/span>\n};<\/span><\/span>\n```<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Save the content in a file named example.md<\/code>. And then run tvdformat example.md<\/code>. This will format this file with default settings. Default means with the embedded advanced settings (xml) and the default custom settings (arbori).<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
The result should look like this:<\/p>\n\n\n\n
example.md (formatted)<\/span><\/path><\/path><\/svg><\/span>
## SQL to be formated<\/span><\/span>\n <\/span><\/span>\n``` sql<\/span><\/span>\nSELECT<\/span> *<\/span><\/span>\n  <\/span>FROM<\/span> EMP<\/span><\/span>\n  <\/span>JOIN<\/span> DEPT<\/span><\/span>\nON<\/span> EMP.DEPTNO = DEPT.DEPTNO;<\/span><\/span>\n```<\/span><\/span>\n <\/span><\/span>\n## SQL to be ignored<\/span><\/span>\n <\/span><\/span>\n```<\/span><\/span>\nSELECT * FROM EMP JOIN DEPT ON EMP.DEPTNO = DEPT.DEPTNO;<\/span><\/span>\n```<\/span><\/span>\n <\/span><\/span>\n## JavaScript to be ignored<\/span><\/span>\n <\/span><\/span>\n``` js<\/span><\/span>\nvar<\/span> <\/span>foo<\/span> = <\/span>function<\/span> (<\/span>bar<\/span>) {<\/span><\/span>\n  <\/span>return<\/span> <\/span>bar<\/span>++;<\/span><\/span>\n};<\/span><\/span>\n```<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
As you see only the first SQL statement is formatted. The other code blocks are left as is. Only code blocks with sql<\/code> syntax highlighting are formatted.<\/p>\n\n\n\n
The indentation of line 7 is wrong. It’s an issue of the default Arbori program. It’s addressed in trivadis_custom_format.arbori<\/code>. However,  we do not want to format the code blocks anyway. We just want to change the keywords and identifiers to lowercase.<\/p>\n\n\n\n
Changing Keywords and Identifiers to Lowercase<\/h2>\n\n\n\n
You can export the advanced format settings in SQL Developer. When you look at the options in the resulting XML file, the first option is adjustCaseOnly<\/code>. This option cannot be set in the Advanced Format preferences. It’s set to false<\/code> by default. When changed to true<\/code> the formatter still executes some part of the Arbori program, but basically skips all actions that deal with whitespace before a node. Knowing that we can create the following options.xml<\/code> file:<\/p>\n\n\n\n
options.xml<\/span><\/path><\/path><\/svg><\/span>
<<\/span>options<\/span>><\/span><\/span>\n    <\/span><<\/span>adjustCaseOnly<\/span>><\/span>true<\/span><\/<\/span>adjustCaseOnly<\/span>><\/span><\/span>\n    <\/span><<\/span>idCase<\/span>><\/span>oracle.dbtools.app.Format.Case.lower<\/span><\/<\/span>idCase<\/span>><\/span><\/span>\n    <\/span><<\/span>kwCase<\/span>><\/span>oracle.dbtools.app.Format.Case.lower<\/span><\/<\/span>kwCase<\/span>><\/span><\/span>\n<\/<\/span>options<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Let’s reset the content of example.md<\/code> to the unformatted one. And then run tvdformat example.md xml=options.xml<\/code>.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Now, the result should look like this:<\/p>\n\n\n\n
example.md (formatted with options.xml)<\/span><\/path><\/path><\/svg><\/span>
## SQL to be formated<\/span><\/span>\n<\/span>\n``` sql<\/span><\/span>\nselect<\/span> * <\/span>from<\/span> emp <\/span>join<\/span> dept <\/span>on<\/span> emp.deptno = dept.deptno;<\/span><\/span>\n```<\/span><\/span>\n<\/span>\n## SQL to be ignored<\/span><\/span>\n<\/span>\n```<\/span><\/span>\nSELECT * FROM EMP JOIN DEPT ON EMP.DEPTNO = DEPT.DEPTNO;<\/span><\/span>\n```<\/span><\/span>\n<\/span>\n## JavaScript to be ignored<\/span><\/span>\n<\/span>\n``` js<\/span><\/span>\nvar<\/span> <\/span>foo<\/span> = <\/span>function<\/span> (<\/span>bar<\/span>) {<\/span><\/span>\n  <\/span>return<\/span> <\/span>bar<\/span>++;<\/span><\/span>\n};<\/span><\/span>\n```<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
As before, only the first code block changed. In this case, everything is in lowercase. However, the processing is more complicated behind the scenes. For example: comments, strings, and quoted identifiers are left untouched. So, it’s more than just a simple .toLowerCase() call and for sure worth using Oracle’s formatter for this task.<\/p>\n\n\n\n
Bulk Processing<\/h2>\n\n\n\n
In our case, we know that we do not have JSON-based code snippets in our Markdown files. Therefore it is safe to change the case of identifiers in all files.<\/p>\n\n\n\n
To process all files in the docs<\/code> directory including all subdirectories I run tvdformat docs xml=options.xml arbori=default<\/code>. I pass the arbori option only to avoid the warning message.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
In this case, the code is based on a Git repository. Therefore I can browse through the changes before committing them. Here’s an excerpt of the g-1050.md<\/code> file.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
You see that the original whitespace is preserved. Only keywords and identifiers are changed to lowercase. The string ‘AD_PERS’ is still in uppercase. This looks good. Ready to be checked in.<\/p>\n\n\n\n
Recommendations<\/h2>\n\n\n\n
The current formatter settings are probably not good enough for all code. There are for sure some cases where the original code base is formatted so badly, that an imperfect formatting configuration leads to a huge improvement. But generally, this is not good enough. You can use the formatter when writing code. That includes changing existing code when the current formatting style makes it difficult to read. You can always select a portion of code (a subquery, a function, etc.), format it and then change the things you don’t like. It’s easy to undo the changes in the IDE. This is also possible if you apply the formatter for a large number of files, especially if you use a version control system such as Git. It is simple to undo everything. However, when you change hundreds of files you will easily overlook some uglified code.<\/p>\n\n\n\n
For bulk processing, changing the case of keywords is safe. Changing the case of identifiers is possible. But be careful, if you are using case-sensitive SQL, this will break your code.<\/p>\n\n\n\n
Whatever you do, make sure you keep the version before applying the formatter. And do not forget to test and review the result.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction Everything Changes. Our Trivadis SQL & PL\/SQL Coding Guidelines are no exceptions. We plan to change rule #1 of our coding styles. From “Keywords are written uppercase, names are written in lowercase.”  to “Keywords and names are written in lowercase.“. We have 103 Markdown files and most of them contain several [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":10506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[129,135,13,85,87,126],"class_list":["post-10477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-arbori","tag-javascript","tag-plsql","tag-sql","tag-sql-developer","tag-sqlcl"],"yoast_head":"\nFormatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-28T13:53:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-12T12:51:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"473\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Formatting SQL Code Blocks in Markdown Files\",\"datePublished\":\"2020-08-28T13:53:57+00:00\",\"dateModified\":\"2023-11-12T12:51:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/\"},\"wordCount\":980,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/uppercase-lowercase-meme4.png\",\"keywords\":[\"Arbori\",\"JavaScript\",\"PL\\\/SQL\",\"SQL\",\"SQL Developer\",\"SQLcl\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/\",\"name\":\"Formatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/uppercase-lowercase-meme4.png\",\"datePublished\":\"2020-08-28T13:53:57+00:00\",\"dateModified\":\"2023-11-12T12:51:52+00:00\",\"description\":\"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/uppercase-lowercase-meme4.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/uppercase-lowercase-meme4.png\",\"width\":473,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/08\\\/28\\\/formatting-sql-code-blocks-in-markdown-files\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formatting SQL Code Blocks in Markdown Files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog","description":"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/","og_locale":"en_US","og_type":"article","og_title":"Formatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog","og_description":"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.","og_url":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2020-08-28T13:53:57+00:00","article_modified_time":"2023-11-12T12:51:52+00:00","og_image":[{"width":473,"height":450,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Formatting SQL Code Blocks in Markdown Files","datePublished":"2020-08-28T13:53:57+00:00","dateModified":"2023-11-12T12:51:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/"},"wordCount":980,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png","keywords":["Arbori","JavaScript","PL\/SQL","SQL","SQL Developer","SQLcl"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/","url":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/","name":"Formatting SQL Code Blocks in Markdown Files - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png","datePublished":"2020-08-28T13:53:57+00:00","dateModified":"2023-11-12T12:51:52+00:00","description":"Format SQL code blocks in more than hundred Markdown files. Configure the formatter to change the case of keywords and identifiers only.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/08\/uppercase-lowercase-meme4.png","width":473,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2020\/08\/28\/formatting-sql-code-blocks-in-markdown-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Formatting SQL Code Blocks in Markdown Files"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/10477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=10477"}],"version-history":[{"count":26,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/10477\/revisions"}],"predecessor-version":[{"id":12687,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/10477\/revisions\/12687"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/10506"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=10477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=10477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=10477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Is it Safe to Change the Case in PL\/SQL & SQL?<\/h2>\n\n\n\n
PL\/SQL & SQL are case-insensitive languages. So you might be tempted to answer this question with “Yes”. But it is not that easy. For keywords, it’s 100% true. However, this is not true for identifiers. Roger Troller<\/a> was the first who showed me examples of unquoted, case-sensitive identifiers in SQL. One is documented here<\/a>.\u00a0 For example, if you use JSON columns the items in the JSON document are case-sensitive. Changing the case will break the code. That’s bad. This is also the reason, why we do not change the case of identifiers in our formatter configuration<\/a>.<\/p>\n\n\n\n
Therefore, be careful, if you change the case of identifiers. This might break your code. Depending on your test coverage you might detect this problem very late, because the program might still compile, but not produce the expected results anymore (as in the mentioned example).<\/p>\n\n\n\n