19 responses

  1. Amberr Meadows
    December 12, 2012

    I really wish I could understand half of these posts, but I am at least going to be here in support :-)

    • thatjeffsmith
      thatjeffsmith
      December 12, 2012

      And I do appreciate your support Amber! I’d write more personal tech based posts, but my core audience are the software and database geeks.

      Maybe I’ll try writing more personal based stuff on the weekends before the kids drive me crazy :)

  2. Gary Vetter
    February 22, 2013

    I followed the instructions for changing keywords to uppercase as I type (Database->SQL Formatter->Oracle Formatting->Edit->Other->Case change->Keywords Uppercase; then Code Editor->Completion Insight->Change case as you type->Upper Keywords), but the case never changes until I hit Enter for a new line. Did I miss something?

    • thatjeffsmith
      thatjeffsmith
      March 1, 2013

      I don’t think you’re missing anything, I think the tool’s behavior isn’t living up to the promise of that preference. Let me investigate…

  3. Jason
    February 28, 2013

    I know a lot of people like upper-cased SQL and PL;/SQL, but to me it’s always looked like somebody’s SHOUTING all the time. Much prefer lower-cased code, and upper-cased tables and columns. Anyway, thanks for the tip.

    • thatjeffsmith
      thatjeffsmith
      March 1, 2013

      I’m with you mostly, although I will Initcap somethings…

  4. Rinie
    May 28, 2013

    Nice posts Jeff!
    I’m missing more options in this formatter tool comparing this to Toad. For example I want also capitals for variable names. The option “Whole SQL Uppercase” is not a solution, this option corrupts our SQL.
    Will the upcoming new releases satisfy our needs? :-)

    • thatjeffsmith
      thatjeffsmith
      May 28, 2013

      That particular uppercase preference is still lacking Rinie. I think it’s something we could probably add though. Would you mind submitting it to our Exchange?

      • Rinie
        May 28, 2013

        @Jeff: Done! Now see how many people are willing to vote :-) Thanks for your reply!

  5. Senthil
    August 9, 2013

    The setting for “Change case as you type” keep changing automatically even though I set it to “Upper Keywords” option. I’m not sure why it is changing and I wish there is an option to keep it permanent. Any help is appreciated!

    • thatjeffsmith
      thatjeffsmith
      August 12, 2013

      Is this the only preference that keeps changing on you? Maybe you don’t have write permissions on your user directory where the preferences are stored?

  6. bala
    January 15, 2014

    I have SQL Developer 4.0.0.13 (build 30). I have choose the option of UpperCase but I see this happens only after I press Enter (but not if I press enter twice) but not as I type.

    Please help. Thanks
    Bala

  7. Meddy
    May 1, 2014

    Thank you so much. It is really useful. Appreciate your help

    • thatjeffsmith
      thatjeffsmith
      May 1, 2014

      You’re welcome Meddy!

  8. Arnold van Koppen
    July 9, 2014

    Jeff,

    SQL Developer is not recognizing all keywords (e.g. EXCEPTION, ELSIF, RAISE, LOOP, OUT, NOCOPY) for formatting. It’s showing them in blue, but is not capitalizing them. Is there a way to fix this manually?

    Also, would it be possible to not show column names colored/capitalized if they match a keyword and they are prefixed with a table (e.g. mytab.value ). I understand it could be hard if the column names are not prefixed, but I think for prefixed columns it should be possible.

    Thanks,

    Arnold van Koppen

    • Ryan Snead
      October 30, 2014

      Any more word on correcting the recognition and formatting of keywords by SQL Formatter that Arnold points out?

      Is there alternatively a workaround in a configuration file?

  9. Dan Murphy
    September 19, 2014

    Thanks for the post – it was so close to getting me what I was looking for. In the completion insight preferences, why isn’t there an option for “Upper Keywords, Lower Identifiers” like the original example you gave in the post? Something like…

    SELECT t.bleh
    FROM table t
    WHERE t.bleh = ‘This would be awesome';

    How can we make that happen?

    Thanks,
    Dan

    • thatjeffsmith
      thatjeffsmith
      September 19, 2014

      Yeah, that used to be there – I doubt it was removed intentionally. I’ll go pester the developer and see what’s what.

  10. Dan Murphy
    September 19, 2014

    Ok, that makes me feel better – I swear it was there in v2 or v3. I am so used to having everything formatted that way and I couldn’t figure out why it wasn’t allowing it anymore.

    Thanks a ton.
    Dan

Leave a Reply

 

 

 

Back to top
mobile desktop