<div>
Tools / Preferences / Database / SQL Formatter / Other <br />
change the Case option to &quot;Whole SQL Lowercase&quot;<br />
<br />
<br />
I'm not sure what you mean by the formatter changing the alignment of your code. 
</div>


<div>
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. &nbsp;It's when Code Insight gives the list of columns in the table (using the table alias). &nbsp;At the moment, these all appear as upper case in the list and consequently in the code (which looks crap). &nbsp;I figure there should be a way to get the list of columns in lower case, but I can't find the right option.<br />
<br />
In terms of the formatter re-aligning my code, please see attached code. &nbsp;I assume I could change the formatting setup if I had the SQL Formatter option under Tools/Preference/Database,<wbr /> but I don't. &nbsp;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.<br />

<pre><code class="code-1 nolinks" id="code-277145"><span>--I like to have my code aligned as follows:</span>
<span>SELECT *</span>
<span>FROM   patients patnt</span>
<span>WHERE  patnt.pasid = '123456';</span>
<span> </span>
<span>--If I get the SQL Formatter to format it, I get this result:</span>
<span>SELECT *</span>
<span>FROM patients patnt</span>
<span>WHERE patnt.pasid = '123456';</span>
</code></pre>
</div>


<div>
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.
</div>


<div>
<div class="content wysiwyg-content">
Does anyone know how to change the Code Insight for Oracle SQL developer to use all lowercase for the auto complete. &nbsp;At the moment mine is set to upper case and this makes my code look crap (and it's a complete PITA to have to convert it all to lowercase)? &nbsp;I have tried the SQL developer help to no avail and I can't find any options that make any difference.<br />
<br />
I realise I can do this if I use the SQL developer formatter, however this changes the allignment of my code so I still have to do manual correction.<br />
<br />
Any help is appreciated.
</div>
</div>


Does anyone know how to change the Code Insight for Oracle SQL developer to use all lowercase for the auto complete.  At the moment mine is set to upper case and this makes my code look crap (and it's a complete PITA to have to convert it all to lowercase)?  I have tried the SQL developer help to no avail and I can't find any options that make any difference.

I realise I can do this if I use the SQL developer formatter, however this changes the allignment of my code so I still have to do manual correction.

Any help is appreciated.

Oracle SQLdeveloper code insight to lower case

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.