{"id":10610,"date":"2020-09-28T12:04:35","date_gmt":"2020-09-28T10:04:35","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=10610"},"modified":"2023-11-12T13:54:44","modified_gmt":"2023-11-12T12:54:44","slug":"disable-formatter-for-code-sections-in-sql-developer","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/","title":{"rendered":"Disable Formatter for Code Sections in SQL Developer"},"content":{"rendered":"\n

In this blog post, I show how you can disable the formatter for some parts of your code. IntelliJ IDEA and the Eclipse IDE use tags in comments to identify sections of code that must not be formatted. By default, these tags are `@formatter:off` and `@formatter:on`.<\/p>\n\n\n\n

Example<\/h2>\n\n\n\n
Example without tags (before)<\/span><\/path><\/path><\/svg><\/span>
SET<\/span> SERVEROUTPUT <\/span>ON<\/span><\/span>\n--<\/span><\/span>\n      <\/span>begin<\/span>                                 <\/span>for<\/span> rec <\/span><\/span>\n   <\/span>in<\/span>(<\/span>select<\/span> r                          .country_region<\/span><\/span>\n  <\/span>as<\/span> region ,p .                       prod_category,<\/span>sum<\/span>(<\/span><\/span>\n s.amount_sold ) <\/span>as<\/span>                  amount_sold <\/span>from<\/span> sales<\/span><\/span>\ns <\/span>join<\/span> products p <\/span>on<\/span>                p . prod_id = s .prod_id<\/span><\/span>\njoin<\/span> customers cust <\/span>on<\/span>           cust.cust_id=s.cust_id <\/span>join<\/span><\/span>\ntimes t <\/span>on<\/span> t . time_id =s.     time_id <\/span>join<\/span> countries r <\/span>on<\/span><\/span>\n  r.country_id = cust.country_id  <\/span>where<\/span>  calendar_year =<\/span><\/span>\n     <\/span>2000<\/span> <\/span>group by<\/span> r.country_region , p.prod_category<\/span><\/span>\n       <\/span>order by<\/span> r .country_region, p.prod_category<\/span><\/span>\n         ) <\/span>loop<\/span> <\/span>if<\/span> rec . region = <\/span>'Asia'<\/span> <\/span>then<\/span> <\/span>if<\/span><\/span>\n           rec.prod_category = <\/span>'Hardware'<\/span> <\/span>then<\/span><\/span>\n             <\/span>\/* print only one line for demo<\/span><\/span>\n                purposes *\/<\/span>sys.dbms_output<\/span><\/span>\n                  . put_line ( <\/span>'Amount: '<\/span><\/span>\n                    ||rec.amount_sold);<\/span><\/span>\n                      <\/span>end if<\/span>;<\/span>end if<\/span>;<\/span><\/span>\n                        <\/span>end loop<\/span>;<\/span><\/span>\n                          <\/span>end<\/span>;<\/span><\/span>\n                           \/<\/span><\/span>\n--<\/span><\/span>\nSELECT<\/span> FISCAL_YEAR, <\/span>COUNT<\/span>(*) <\/span>FROM<\/span> SALES S <\/span><\/span>\nNATURAL JOIN<\/span> TIMES T <\/span>GROUP BY<\/span> FISCAL_YEAR <\/span>ORDER BY<\/span> <\/span>1<\/span>;<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
When I format this code with SQL Developer 20.2 and the default Trivadis PL\/SQL & SQL Formatter Settings<\/a> (plus lowercase keywords, lowercase identifiers) the result looks like this:<\/p>\n\n\n\n
Example without tags (after)<\/span><\/path><\/path><\/svg><\/span>
set<\/span> serveroutput <\/span>on<\/span><\/span>\n--<\/span><\/span>\nbegin<\/span><\/span>\n   <\/span>for<\/span> rec <\/span>in<\/span> (<\/span><\/span>\n      <\/span>select<\/span> r.country_region <\/span>as<\/span> region,<\/span><\/span>\n             p.prod_category,<\/span><\/span>\n             <\/span>sum<\/span>(s.amount_sold) <\/span>as<\/span> amount_sold<\/span><\/span>\n        <\/span>from<\/span> sales s<\/span><\/span>\n        <\/span>join<\/span> products p<\/span><\/span>\n          <\/span>on<\/span> p.prod_id = s.prod_id<\/span><\/span>\n        <\/span>join<\/span> customers cust<\/span><\/span>\n          <\/span>on<\/span> cust.cust_id = s.cust_id<\/span><\/span>\n        <\/span>join<\/span> times t<\/span><\/span>\n          <\/span>on<\/span> t.time_id = s.time_id<\/span><\/span>\n        <\/span>join<\/span> countries r<\/span><\/span>\n          <\/span>on<\/span> r.country_id = cust.country_id<\/span><\/span>\n       <\/span>where<\/span> calendar_year = <\/span>2000<\/span><\/span>\n       <\/span>group by<\/span> r.country_region,<\/span><\/span>\n                p.prod_category<\/span><\/span>\n       <\/span>order by<\/span> r.country_region,<\/span><\/span>\n                p.prod_category<\/span><\/span>\n   ) <\/span>loop<\/span><\/span>\n      <\/span>if<\/span> rec.region = <\/span>'Asia'<\/span> <\/span>then<\/span><\/span>\n         <\/span>if<\/span> rec.prod_category = <\/span>'Hardware'<\/span> <\/span>then<\/span><\/span>\n             <\/span>\/* print only one line for demo<\/span><\/span>\n                purposes *\/<\/span><\/span>\n            sys.<\/span>dbms_output.<\/span>put_line<\/span>(<\/span>'Amount: '<\/span> || rec.amount_sold);<\/span><\/span>\n         <\/span>end if<\/span>;<\/span><\/span>\n      <\/span>end if<\/span>;<\/span><\/span>\n   <\/span>end loop<\/span>;<\/span><\/span>\nend<\/span>;<\/span><\/span>\n\/<\/span><\/span>\n--<\/span><\/span>\nselect<\/span> fiscal_year,<\/span><\/span>\n       <\/span>count<\/span>(*)<\/span><\/span>\n  <\/span>from<\/span> sales s<\/span><\/span>\nnatural join<\/span> times t<\/span><\/span>\n <\/span>group by<\/span> fiscal_year<\/span><\/span>\n <\/span>order by<\/span> <\/span>1<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Argh, I do not want the PL\/SQL block to be formatted. I spent enough time to format it manually and I want to keep it that way. Let’s add `@formatter:off` and `@formatter:on` tags to the original code like this:<\/p>\n\n\n\n
Example with tags (before)<\/span><\/path><\/path><\/svg><\/span>
SET<\/span> SERVEROUTPUT <\/span>ON<\/span><\/span>\n-- @formatter:off<\/span><\/span>\n      <\/span>begin<\/span>                                 <\/span>for<\/span> rec <\/span><\/span>\n   <\/span>in<\/span>(<\/span>select<\/span> r                          .country_region<\/span><\/span>\n  <\/span>as<\/span> region ,p .                       prod_category,<\/span>sum<\/span>(<\/span><\/span>\n s.amount_sold ) <\/span>as<\/span>                  amount_sold <\/span>from<\/span> sales<\/span><\/span>\ns <\/span>join<\/span> products p <\/span>on<\/span>                p . prod_id = s .prod_id<\/span><\/span>\njoin<\/span> customers cust <\/span>on<\/span>           cust.cust_id=s.cust_id <\/span>join<\/span><\/span>\ntimes t <\/span>on<\/span> t . time_id =s.     time_id <\/span>join<\/span> countries r <\/span>on<\/span><\/span>\n  r.country_id = cust.country_id  <\/span>where<\/span>  calendar_year =<\/span><\/span>\n     <\/span>2000<\/span> <\/span>group by<\/span> r.country_region , p.prod_category<\/span><\/span>\n       <\/span>order by<\/span> r .country_region, p.prod_category<\/span><\/span>\n         ) <\/span>loop<\/span> <\/span>if<\/span> rec . region = <\/span>'Asia'<\/span> <\/span>then<\/span> <\/span>if<\/span><\/span>\n           rec.prod_category = <\/span>'Hardware'<\/span> <\/span>then<\/span><\/span>\n             <\/span>\/* print only one line for demo<\/span><\/span>\n                purposes *\/<\/span>sys.dbms_output<\/span><\/span>\n                  . put_line ( <\/span>'Amount: '<\/span><\/span>\n                    ||rec.amount_sold);<\/span><\/span>\n                      <\/span>end if<\/span>;<\/span>end if<\/span>;<\/span><\/span>\n                        <\/span>end loop<\/span>;<\/span><\/span>\n                          <\/span>end<\/span>;<\/span><\/span>\n                           \/<\/span><\/span>\n-- @formatter:on<\/span><\/span>\nSELECT<\/span> FISCAL_YEAR, <\/span>COUNT<\/span>(*) <\/span>FROM<\/span> SALES S <\/span><\/span>\nNATURAL JOIN<\/span> TIMES T <\/span>GROUP BY<\/span> FISCAL_YEAR <\/span>ORDER BY<\/span> <\/span>1<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Now the formatter keeps the PL\/SQL block as it is and formats only the rest.<\/p>\n\n\n\n
Example with tags (after)<\/span><\/path><\/path><\/svg><\/span>
set<\/span> serveroutput <\/span>on<\/span><\/span>\n-- @formatter:off<\/span><\/span>\n      <\/span>begin<\/span>                                 <\/span>for<\/span> rec <\/span><\/span>\n   <\/span>in<\/span>(<\/span>select<\/span> r                          .country_region<\/span><\/span>\n  <\/span>as<\/span> region ,p .                       prod_category,<\/span>sum<\/span>(<\/span><\/span>\n s.amount_sold ) <\/span>as<\/span>                  amount_sold <\/span>from<\/span> sales<\/span><\/span>\ns <\/span>join<\/span> products p <\/span>on<\/span>                p . prod_id = s .prod_id<\/span><\/span>\njoin<\/span> customers cust <\/span>on<\/span>           cust.cust_id=s.cust_id <\/span>join<\/span><\/span>\ntimes t <\/span>on<\/span> t . time_id =s.     time_id <\/span>join<\/span> countries r <\/span>on<\/span><\/span>\n  r.country_id = cust.country_id  <\/span>where<\/span>  calendar_year =<\/span><\/span>\n     <\/span>2000<\/span> <\/span>group by<\/span> r.country_region , p.prod_category<\/span><\/span>\n       <\/span>order by<\/span> r .country_region, p.prod_category<\/span><\/span>\n         ) <\/span>loop<\/span> <\/span>if<\/span> rec . region = <\/span>'Asia'<\/span> <\/span>then<\/span> <\/span>if<\/span><\/span>\n           rec.prod_category = <\/span>'Hardware'<\/span> <\/span>then<\/span><\/span>\n             <\/span>\/* print only one line for demo<\/span><\/span>\n                purposes *\/<\/span>sys.dbms_output<\/span><\/span>\n                  . put_line ( <\/span>'Amount: '<\/span><\/span>\n                    ||rec.amount_sold);<\/span><\/span>\n                      <\/span>end if<\/span>;<\/span>end if<\/span>;<\/span><\/span>\n                        <\/span>end loop<\/span>;<\/span><\/span>\n                          <\/span>end<\/span>;<\/span><\/span>\n                           \/<\/span><\/span>\n-- @formatter:on<\/span><\/span>\nselect<\/span> fiscal_year,<\/span><\/span>\n       <\/span>count<\/span>(*)<\/span><\/span>\n  <\/span>from<\/span> sales s<\/span><\/span>\nnatural join<\/span> times t<\/span><\/span>\n <\/span>group by<\/span> fiscal_year<\/span><\/span>\n <\/span>order by<\/span> <\/span>1<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Configure SQL Developer<\/h2>\n\n\n\n
To configure this solution you need SQL Developer 19.2 or later. Open the preferences dialog and go to Code Editor<\/code> -> Format<\/code> -> Advanced Format<\/code> -> Custom Format<\/code> .<\/p>\n\n\n\n
Add the following Arbori query (e.g. after the dontFormatNode<\/code> query). The position is not that important.<\/p>\n\n\n\n
Arbori query ‘dontFormatOffOnRanges’<\/span>
dontFormatOffOnRanges<\/span>: <\/span>runOnce<\/span> -> {<\/span><\/span>\n    var <\/span>Integer<\/span> = <\/span>Java<\/span>.<\/span>type<\/span>(<\/span>'java.lang.Integer'<\/span>);<\/span><\/span>\n    var <\/span>LexerToken<\/span> = <\/span>Java<\/span>.<\/span>type<\/span>(<\/span>'oracle.dbtools.parser.LexerToken'<\/span>); <\/span><\/span>\n    var <\/span>Token<\/span> = <\/span>Java<\/span>.<\/span>type<\/span>(<\/span>'oracle.dbtools.parser.Token'<\/span>);<\/span><\/span>\n    var <\/span>tokens<\/span> = <\/span>LexerToken<\/span>.<\/span>parse<\/span>(<\/span>target<\/span>.<\/span>input<\/span>, <\/span>true<\/span>);  <\/span>\/\/ include hidden tokens not relevant to build a parse tree<\/span><\/span>\n    var <\/span>hiddenTokenCount<\/span> = <\/span>0<\/span>;<\/span><\/span>\n    var <\/span>format<\/span> = <\/span>true<\/span>;<\/span><\/span>\n    <\/span>for<\/span> (<\/span>var<\/span> <\/span>i<\/span> <\/span>in<\/span> <\/span>tokens<\/span>) {<\/span><\/span>\n      <\/span>if<\/span> (<\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>type<\/span> == <\/span>Token<\/span>.<\/span>LINE_COMMENT<\/span> || <\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>type<\/span> == <\/span>Token<\/span>.<\/span>COMMENT<\/span>) {<\/span><\/span>\n        <\/span>if<\/span> (<\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>content<\/span>.<\/span>toLowerCase<\/span>().<\/span>contains<\/span>(<\/span>"@formatter:off"<\/span>) ||<\/span><\/span>\n            <\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>content<\/span>.<\/span>toLowerCase<\/span>().<\/span>contains<\/span>(<\/span>"noformat start"<\/span>)) <\/span><\/span>\n        {<\/span><\/span>\n          <\/span>format<\/span> = <\/span>false<\/span>;<\/span><\/span>\n        }<\/span><\/span>\n        <\/span>if<\/span> (<\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>content<\/span>.<\/span>toLowerCase<\/span>().<\/span>contains<\/span>(<\/span>"@formatter:on"<\/span>) ||<\/span><\/span>\n            <\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>content<\/span>.<\/span>toLowerCase<\/span>().<\/span>contains<\/span>(<\/span>"noformat end"<\/span>))<\/span><\/span>\n        {<\/span><\/span>\n          <\/span>format<\/span> = <\/span>true<\/span>;<\/span><\/span>\n        }<\/span><\/span>\n        <\/span>hiddenTokenCount<\/span>++;<\/span><\/span>\n      } <\/span>else<\/span> <\/span>if<\/span> (<\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>type<\/span> == <\/span>Token<\/span>.<\/span>WS<\/span> || <\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>type<\/span> == <\/span>Token<\/span>.<\/span>MACRO_SKIP<\/span> ||<\/span><\/span>\n                 <\/span>tokens<\/span>[<\/span>i<\/span>].<\/span>type<\/span> == <\/span>Token<\/span>.<\/span>SQLPLUSLINECONTINUE_SKIP<\/span>) <\/span><\/span>\n      {<\/span><\/span>\n        <\/span>hiddenTokenCount<\/span>++<\/span><\/span>\n      } <\/span>else<\/span> {  <\/span><\/span>\n        <\/span>\/* expected types: QUOTED_STRING, DQUOTED_STRING, BQUOTED_STRING, DIGITS, <\/span><\/span>\n                           OPERATION, IDENTIFIER, AUXILIARY, INCOMPLETE *\/<\/span><\/span>\n        <\/span>if<\/span> (!<\/span>format<\/span>) {<\/span><\/span>\n          <\/span>struct<\/span>.<\/span>unformattedPositions<\/span>.<\/span>add<\/span>(<\/span>new<\/span> <\/span>Integer<\/span>(<\/span>i<\/span>-<\/span>hiddenTokenCount<\/span>));<\/span><\/span>\n        }<\/span><\/span>\n      }<\/span><\/span>\n    }<\/span><\/span>\n  }<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Here are some explanations:<\/p>\n\n\n\n
SQL Developer’s formatter class has a public field named unformattedPositions<\/code> of type\u00a0 Set<Integer><\/code>. It contains all token positions that must not be formatted. We just have to extend this set. However, the parse tree contains only relevant tokens. The whitespace and comments are not relevant. But we need single-line and multi-line comments to disable and enable the formatter. That’s why we read all tokens on line 5. Now we can determine if a token should be added to the unformattedPositions<\/code> on line 29. The variable i<\/code> contains the current token position. The hiddenTokenCount<\/code> contains the number of preceding tokens that are not part of the parse tree. i-hiddenTokenCount<\/code> equates to the token position in the parse tree. The rest should be self-explanatory.<\/p>\n\n\n\n
Read this post<\/a> to learn more about Arbori and how the formatter works.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this blog post, I show how you can disable the formatter for some parts of your code. IntelliJ IDEA and the Eclipse IDE use tags in comments to identify sections of code that must not be formatted. By default, these tags are `@formatter:off` and `@formatter:on`. Example When I format this code [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":10635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[129,135,13,85,87],"class_list":["post-10610","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-arbori","tag-javascript","tag-plsql","tag-sql","tag-sql-developer"],"yoast_head":"\nDisable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.\" \/>\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\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Disable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-28T10:04:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-12T12:54:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"718\" \/>\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=\"3 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\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Disable Formatter for Code Sections in SQL Developer\",\"datePublished\":\"2020-09-28T10:04:35+00:00\",\"dateModified\":\"2023-11-12T12:54:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/\"},\"wordCount\":387,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/broken_heart.png\",\"keywords\":[\"Arbori\",\"JavaScript\",\"PL\\\/SQL\",\"SQL\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/\",\"name\":\"Disable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/broken_heart.png\",\"datePublished\":\"2020-09-28T10:04:35+00:00\",\"dateModified\":\"2023-11-12T12:54:44+00:00\",\"description\":\"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/broken_heart.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/broken_heart.png\",\"width\":960,\"height\":718},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2020\\\/09\\\/28\\\/disable-formatter-for-code-sections-in-sql-developer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Disable Formatter for Code Sections in SQL Developer\"}]},{\"@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":"Disable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog","description":"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.","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\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/","og_locale":"en_US","og_type":"article","og_title":"Disable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog","og_description":"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.","og_url":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2020-09-28T10:04:35+00:00","article_modified_time":"2023-11-12T12:54:44+00:00","og_image":[{"width":960,"height":718,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Disable Formatter for Code Sections in SQL Developer","datePublished":"2020-09-28T10:04:35+00:00","dateModified":"2023-11-12T12:54:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/"},"wordCount":387,"commentCount":4,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.png","keywords":["Arbori","JavaScript","PL\/SQL","SQL","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/","url":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/","name":"Disable Formatter for Code Sections in SQL Developer - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.png","datePublished":"2020-09-28T10:04:35+00:00","dateModified":"2023-11-12T12:54:44+00:00","description":"In this blog post I show how you can disable the formatter for some parts of your code as in IntelliJ IDEA and the Eclipse IDE.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2020\/09\/broken_heart.png","width":960,"height":718},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2020\/09\/28\/disable-formatter-for-code-sections-in-sql-developer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Disable Formatter for Code Sections in SQL Developer"}]},{"@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\/10610","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=10610"}],"version-history":[{"count":23,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/10610\/revisions"}],"predecessor-version":[{"id":13984,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/10610\/revisions\/13984"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/10635"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=10610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=10610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=10610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
This does not work out of the box. Therefore you have to configure SQL Developer accordingly. Either by importing the latest Trivadis PL\/SQL & SQL Formatter Settings<\/a> (as I’ve done) or by adding an Arbori query yourself. I explain the latter in the next section.<\/p>\n\n\n\n