Alex Rivera | Logout

Oracle SQLDeveloper Autocomplete in Lowercase (How about Uppercase)

Asked 2009-10-21T08:55:13.677
15

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?

oracle-database autocomplete uppercase oracle-sqldeveloper
Edit
Report

1 Answer

7

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).

answered 2009-10-22T12:40:18.993

Your Answer