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?
I'm using SQL Developer 2.1 (EA) from http://www.oracle.com/technology/software/products/sql/index21%5FEA1.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).