Oracle SQLdeveloper code insight to lower case

Tools / Preferences / Database / SQL Formatter / Other
change the Case option to "Whole SQL Lowercase"


I'm not sure what you mean by the formatter changing the alignment of your code.

Hi, thanks for this, I don't have this option in my version of SQL Developer, but also it's not the SQL Formattter case that I want to change.  It's when Code Insight gives the list of columns in the table (using the table alias).  At the moment, these all appear as upper case in the list and consequently in the code (which looks crap).  I figure there should be a way to get the list of columns in lower case, but I can't find the right option.

In terms of the formatter re-aligning my code, please see attached code.  I assume I could change the formatting setup if I had the SQL Formatter option under Tools/Preference/Database, but I don't.  Unfortunately this is a version of SQL Developer installed on a client server so I also don't have any options to reinstall/upgrade etc.

--I like to have my code aligned as follows:
SELECT *
FROM   patients patnt
WHERE  patnt.pasid = '123456';
 
--If I get the SQL Formatter to format it, I get this result:
SELECT *
FROM patients patnt
WHERE patnt.pasid = '123456';

Select allOpen in new window

Thank you for this, I will check the version of SQL Developer on the client server and see if I can get them to update it to the latest.