Oracle SQLDeveloper Autocomplete in Lowercase (How about Uppercase)
autocomplete, oracle, oracle-sqldeveloper, uppercase
Solution
I'm using SQL Developer 2.1 (EA) from http://www.oracle.com/technology/software/products/sql/index21_EA1.html
.. which IMHO is much better than the 'current' version that I believe you're using. In the 2.1 version you can goto Tools > Preferences > Database > SQL Formatter > Oracle Formatting and hit 'Edit' to alter the behaviour of capitalisation effects.
It is my understanding, however, that in a Worksheet this will not 'autoformat' .. it only does this in procedures, packages, views, and triggers. (So you'll have to highligh, right-click, Format to do this in a worksheet).
Problem
I am currently using the latest Oracle sql developer. I just have one nuisance here. When I do auto-complete of table names or columns, they show up in lower case. As most people I do have coding guidelines in SQL statements and I usually want table names, column names, and any other identifiers in all capitals. I tried to check the settings in sql developer and the "Code Insight" section does not have any option for this. Is there any other tweak for this?