Oracle SQLDeveloper Autocomplete in Lowercase (How about Uppercase)

oracle autocomplete uppercase oracle-sqldeveloper
Nap picture Nap · Oct 21, 2009 · Viewed 34.3k times · Source

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?

Answer

Gabriel Rosas picture Gabriel Rosas · Apr 14, 2012

I'm using SQL Developer 3.1.07 and you can change the case of the autocompleted table names by going to Tools > Preferences > Code Editor > Completion Insight there is an option for 'Change case as you type'.

Related questions

Toad: Table Autocomplete Functionality Not Working

I've been using Toad for more than a year now without problems. All of a sudden the table autocomplete feature has ceased working. No settings have been changed, and I've clean installed a new TOAD version, yet the problem persists. …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More