7 responses

  1. Dan T.
    September 10, 2012

    I wish SQL Developer would break out the “more newlines” option, because some of the choices it makes seem unnatural. I’d like to see it put 2 linebreaks at the end of a procedure in a package, but there’s no way to make that happen. I’d like to have “CREATE OR REPLACE PACKAGE packagename” all on 1 line, but seems there’s no way to do that either. I like the right-align master keywords option, but for some reason, the AND-conditions don’t get aligned with it.

    It seems like the SQL Developer formatter still has a lot of quirks. Or maybe I’m the quirky one, still doing all my development in an old version of Formatter Plus, which breaks on all new syntax…

    • thatjeffsmith
      September 10, 2012

      The option, ‘more newlines,’ will insert blank lines in the follow circumstances:

      • before and after (2 lines) most BEGIN END or logical code blocks
      • before Create or Replace, (before function and procedure in packages)
      • two single line comments (that are not embedded in another statement)
      • after THEN before IF

      You can see a code sample updated dynamically as you toggle the ‘More’ preference on and off.

      All this being said there are a few whitespace management issues being looked at for the formatter. Preserving blank lines for example is something we need to address. Formatting improvements are something that will never be ‘finished,’ but since it is a largely subjective area, we heavily rely on our customers to focus our efforts. That includes you here :)

  2. Rich
    September 19, 2012


    Great article… But where did the threshold for small SQL go in SQL Developer 3.2? I can’t seem to find it.



  3. Rich
    September 19, 2012

    OK, found it… You have to open up the formatter and then click the edit button. That wasn’t clear from your post. :)

    • thatjeffsmith
      September 19, 2012

      Great! I was worried we broke something in 3.2.

      Sorry for the unclear path to the options. I think I covered it in an earlier post but will be sure to cover that in formatting posts going forward.

  4. Kuldeep
    November 1, 2013

    This was something that I was looking for …thanks Jeff

  5. Mani
    June 4, 2014

    Please add an option for a linebreak before or after a semi-colon.


Leave a Reply




Back to top
mobile desktop