{"id":11272,"date":"2021-08-29T12:37:42","date_gmt":"2021-08-29T10:37:42","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=11272"},"modified":"2023-11-08T15:35:23","modified_gmt":"2023-11-08T14:35:23","slug":"do-not-format-invalid-code-in-sql-developer","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/","title":{"rendered":"Do Not Format Invalid Code in SQL Developer"},"content":{"rendered":"\n

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

What happens when you call the formatter in SQL Developer for invalid code? Until recently SQL Developer tried to format it anyway. This produced strange results in some cases. Starting with SQL Developer version 21.2.0 there is a hidden option to suppress formatting when the code is invalid.<\/p>\n\n\n\n

What Is Valid Code?<\/h2>\n\n\n\n

If the code can be compiled and executed, it is valid. Right? – Well, SQL Developer uses a parser written in Java. The resulting lexer token stream and the parse tree are essential inputs for the formatter. If the parser does not understand the code then it produces a partial parse tree. This means the parse tree is incomplete. In such cases the formatting result is unreliable. And it does not matter if the code can be compiled and executed.<\/p>\n\n\n\n

Here’s an example of a valid SQL statement that produces a query result but still reports a syntax error.<\/p>\n\n\n\n

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

There are three options in SQL Developer to spot a syntax error in an editor.<\/p>\n\n\n\n

    \n
  1. A pinkish-wavy line below the token (group) in the editor that is responsible for the syntax error. When you hover over it a pop-up window with additional information appears.<\/li>\n\n\n\n
  2. A pink area on the right border of the editor. When you hover over it a pop-up window with the code excerpt appears. When you click on it the cursor is positioned on the token with the pinkish-wavy line (group<\/code>).<\/li>\n\n\n\n
  3. Syntax error; Partial parse tree:<\/code> is shown as the first line in the code outline window<\/li>\n<\/ol>\n\n\n\n

    According to the SQL Language Reference 21c<\/a> this syntax is not allowed.<\/p>\n\n\n\n

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

    However, Oracle’s implementation allows to write the HAVING condition<\/code> before the GROUP BY<\/code>. That’s a fact.<\/p>\n\n\n\n

    As you can see, it is not so easy to write a complete parser based only on the documentation.<\/p>\n\n\n\n

    The Problem<\/h2>\n\n\n\n

    When I call the formatter in SQL Developer with my favourite formatter settings for this code<\/p>\n\n\n\n

    Invalid code<\/span><\/path><\/path><\/svg><\/span>
    select<\/span><\/span>\n   constraint_name<\/span><\/span>\nfrom<\/span><\/span>\n   user_cons_columns c<\/span><\/span>\nwhere<\/span><\/span>\n   c.table_name = <\/span>'EMP'<\/span><\/span>\nhaving<\/span><\/span>\n   <\/span>count<\/span>(<\/span>1<\/span>) = <\/span>1<\/span><\/span>\ngroup by<\/span><\/span>\n   constraint_name;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    then I get the following result:<\/p>\n\n\n\n
    Formatted invalid code<\/span><\/path><\/path><\/svg><\/span>
    select<\/span> constraint_name<\/span><\/span>\n  <\/span>from<\/span> user_cons_columns c<\/span><\/span>\n <\/span>where<\/span> c.table_name = <\/span>'EMP'<\/span><\/span>\nhaving<\/span> <\/span>count<\/span>(<\/span>1<\/span>) = <\/span>1<\/span><\/span>\ngroup by<\/span><\/span>\n   constraint_name;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    When I fix the syntax error (from a SQL Developer’s parser perspective) in the original code like this:<\/p>\n\n\n\n
    Valid code<\/span><\/path><\/path><\/svg><\/span>
    select<\/span><\/span>\n   constraint_name<\/span><\/span>\nfrom<\/span><\/span>\n   user_cons_columns c<\/span><\/span>\nwhere<\/span><\/span>\n   c.table_name = <\/span>'EMP'<\/span><\/span>\ngroup by<\/span><\/span>\n   constraint_name<\/span><\/span>\nhaving<\/span><\/span>\n   <\/span>count<\/span>(<\/span>1<\/span>) = <\/span>1<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    then the formatter result is:<\/p>\n\n\n\n
    Formatted valid code<\/span><\/path><\/path><\/svg><\/span>
    select<\/span> constraint_name<\/span><\/span>\n  <\/span>from<\/span> user_cons_columns c<\/span><\/span>\n <\/span>where<\/span> c.table_name = <\/span>'EMP'<\/span><\/span>\n <\/span>group by<\/span> constraint_name<\/span><\/span>\nhaving<\/span> <\/span>count<\/span>(<\/span>1<\/span>) = <\/span>1<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    In this example the difference is small. Just the group by<\/code> clause which could not be formatted with the syntax error. However, in other cases, the formatter result might be really weird. So in my opinion it is better to not format invalid code.<\/p>\n\n\n\n
    The Solution<\/h2>\n\n\n\n
    Open the preferences in SQL Developer and export the Advanced Format<\/code> settings as shown in this screenshot.<\/p>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n
    Then open the exported XML file in an editor and add the highlighted line:<\/p>\n\n\n\n
    advanced_format.xml<\/span><\/path><\/path><\/svg><\/span>
    <<\/span>options<\/span>><<\/span>adjustCaseOnly<\/span>><\/span>false<\/span><\/<\/span>adjustCaseOnly<\/span>><\/span><\/span>\n<<\/span>alignTabColAliases<\/span>><\/span>true<\/span><\/<\/span>alignTabColAliases<\/span>><\/span><\/span>\n<<\/span>breakOnSubqueries<\/span>><\/span>true<\/span><\/<\/span>breakOnSubqueries<\/span>><\/span><\/span>\n<<\/span>alignEquality<\/span>><\/span>false<\/span><\/<\/span>alignEquality<\/span>><\/span><\/span>\n<<\/span>formatWhenSyntaxError<\/span>><\/span>true<\/span><\/<\/span>formatWhenSyntaxError<\/span>><\/span><\/span>\n<<\/span>singleLineComments<\/span>><\/span>oracle.dbtools.app.Format.InlineComments.CommentsUnchanged<\/span><\/<\/span>singleLineComments<\/span>><\/span><\/span>\n<<\/span>breakAnsiiJoin<\/span>><\/span>false<\/span><\/<\/span>breakAnsiiJoin<\/span>><\/span><\/span>\n<<\/span>maxCharLineSize<\/span>><\/span>128<\/span><\/<\/span>maxCharLineSize<\/span>><\/span><\/span>\n<<\/span>alignAssignments<\/span>><\/span>false<\/span><\/<\/span>alignAssignments<\/span>><\/span><\/span>\n<<\/span>breaksProcArgs<\/span>><\/span>false<\/span><\/<\/span>breaksProcArgs<\/span>><\/span><\/span>\n<<\/span>alignRight<\/span>><\/span>false<\/span><\/<\/span>alignRight<\/span>><\/span><\/span>\n<<\/span>breaksComma<\/span>><\/span>oracle.dbtools.app.Format.Breaks.After<\/span><\/<\/span>breaksComma<\/span>><\/span><\/span>\n<<\/span>breaksAroundLogicalConjunctions<\/span>><\/span>oracle.dbtools.app.Format.Breaks.Before<\/span><\/<\/span>breaksAroundLogicalConjunctions<\/span>><\/span><\/span>\n<<\/span>alignNamedArgs<\/span>><\/span>true<\/span><\/<\/span>alignNamedArgs<\/span>><\/span><\/span>\n<<\/span>formatProgramURL<\/span>><\/span>default<\/span><\/<\/span>formatProgramURL<\/span>><\/span><\/span>\n<<\/span>formatThreshold<\/span>><\/span>1<\/span><\/<\/span>formatThreshold<\/span>><\/span><\/span>\n<<\/span>spaceAroundOperators<\/span>><\/span>true<\/span><\/<\/span>spaceAroundOperators<\/span>><\/span><\/span>\n<<\/span>useTab<\/span>><\/span>false<\/span><\/<\/span>useTab<\/span>><\/span><\/span>\n<<\/span>idCase<\/span>><\/span>oracle.dbtools.app.Format.Case.lower<\/span><\/<\/span>idCase<\/span>><\/span><\/span>\n<<\/span>extraLinesAfterSignificantStatements<\/span>><\/span>oracle.dbtools.app.Format.BreaksX2.X2<\/span><\/<\/span>extraLinesAfterSignificantStatements<\/span>><\/span><\/span>\n<<\/span>breaksConcat<\/span>><\/span>oracle.dbtools.app.Format.Breaks.Before<\/span><\/<\/span>breaksConcat<\/span>><\/span><\/span>\n<<\/span>spaceAroundBrackets<\/span>><\/span>oracle.dbtools.app.Format.Space.Default<\/span><\/<\/span>spaceAroundBrackets<\/span>><\/span><\/span>\n<<\/span>flowControl<\/span>><\/span>oracle.dbtools.app.Format.FlowControl.IndentedActions<\/span><\/<\/span>flowControl<\/span>><\/span><\/span>\n<<\/span>commasPerLine<\/span>><\/span>5<\/span><\/<\/span>commasPerLine<\/span>><\/span><\/span>\n<<\/span>forceLinebreaksBeforeComment<\/span>><\/span>false<\/span><\/<\/span>forceLinebreaksBeforeComment<\/span>><\/span><\/span>\n<<\/span>alignTypeDecl<\/span>><\/span>true<\/span><\/<\/span>alignTypeDecl<\/span>><\/span><\/span>\n<<\/span>breakParenCondition<\/span>><\/span>false<\/span><\/<\/span>breakParenCondition<\/span>><\/span><\/span>\n<<\/span>parseForwardAndBackward<\/span>><\/span>true<\/span><\/<\/span>parseForwardAndBackward<\/span>><\/span><\/span>\n<<\/span>identSpaces<\/span>><\/span>4<\/span><\/<\/span>identSpaces<\/span>><\/span><\/span>\n<<\/span>breaksAfterSelect<\/span>><\/span>true<\/span><\/<\/span>breaksAfterSelect<\/span>><\/span><\/span>\n<<\/span>spaceAfterCommas<\/span>><\/span>true<\/span><\/<\/span>spaceAfterCommas<\/span>><\/span><\/span>\n<<\/span>kwCase<\/span>><\/span>oracle.dbtools.app.Format.Case.UPPER<\/span><\/<\/span>kwCase<\/span>><\/span><\/span>\n<<\/span>formatWhenSyntaxError<\/span>><\/span>false<\/span><\/<\/span>formatWhenSyntaxError<\/span>><\/span><\/span>\n<\/<\/span>options<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    Save the file and import it into the preferences of SQL Developer. It’s the same screen as before, but this time use the Import<\/code> button.<\/p>\n\n\n\n
    Afterwards, SQL Developer will format valid code only.<\/p>\n\n\n\n
    Summary<\/h2>\n\n\n\n
    Now you can decide whether you want to format code with syntax errors in SQL Developer. I recommend not to format invalid code. In most cases, you will not be satisfied with the result anyway. And with larger files, you may not realize until much later that undo is no longer a simple keyboard shortcut.<\/p>\n\n\n\n
    Many thanks to the SQL Developer team and especially to Vadim Tropashko for implementing this enhancement request<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Introduction What happens when you call the formatter in SQL Developer for invalid code? Until recently SQL Developer tried to format it anyway. This produced strange results in some cases. Starting with SQL Developer version 21.2.0 there is a hidden option to suppress formatting when the code is invalid. What Is Valid [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":11290,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[129,87],"class_list":["post-11272","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-arbori","tag-sql-developer"],"yoast_head":"\nDo Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.\" \/>\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\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Do Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-29T10:37:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T14:35:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Do Not Format Invalid Code in SQL Developer\",\"datePublished\":\"2021-08-29T10:37:42+00:00\",\"dateModified\":\"2023-11-08T14:35:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/\"},\"wordCount\":550,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/pexels-ann-h-3482441-scaled.jpg\",\"keywords\":[\"Arbori\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/\",\"name\":\"Do Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/pexels-ann-h-3482441-scaled.jpg\",\"datePublished\":\"2021-08-29T10:37:42+00:00\",\"dateModified\":\"2023-11-08T14:35:23+00:00\",\"description\":\"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/pexels-ann-h-3482441-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/pexels-ann-h-3482441-scaled.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2021\\\/08\\\/29\\\/do-not-format-invalid-code-in-sql-developer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Do Not Format Invalid Code 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":"Do Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog","description":"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.","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\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/","og_locale":"en_US","og_type":"article","og_title":"Do Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog","og_description":"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.","og_url":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2021-08-29T10:37:42+00:00","article_modified_time":"2023-11-08T14:35:23+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg","type":"image\/jpeg"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Do Not Format Invalid Code in SQL Developer","datePublished":"2021-08-29T10:37:42+00:00","dateModified":"2023-11-08T14:35:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/"},"wordCount":550,"commentCount":5,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg","keywords":["Arbori","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/","url":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/","name":"Do Not Format Invalid Code in SQL Developer - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg","datePublished":"2021-08-29T10:37:42+00:00","dateModified":"2023-11-08T14:35:23+00:00","description":"Until recently SQL Developer tried to format invalid code. This produced strange results. Don't format invalid code. There's an option now.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2021\/08\/pexels-ann-h-3482441-scaled.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2021\/08\/29\/do-not-format-invalid-code-in-sql-developer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Do Not Format Invalid Code 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\/11272","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=11272"}],"version-history":[{"count":14,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/11272\/revisions"}],"predecessor-version":[{"id":12711,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/11272\/revisions\/12711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/11290"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=11272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=11272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=11272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
    The latest Trivadis PL\/SQL & SQL Formatter Settings<\/a> also use <formatWhenSyntaxError>false<\/formatWhenSyntaxError><\/code>.<\/p>\n\n\n\n