SQL Developer code formatting

I have just cut 'n' paste some SQL code into SQL developer (4.0.2.15). I have a right margin set and selected CTRL+F7 to format it. However I have two problems

• The code is wider that the right margin I have set

• The keywords are in capitals and the coding standard here is lowercase.

I have been unable to find how to change this or is this possible?

I did a google search for the phrase "sql developer code formatting", and the first hit was this:

http://www.thatjeffsmith.com/archive/2014/03/how-to-make-your-code-look-like-steven-feuersteins-in-oracle-sql-developer/

Have a read through that blog post from Jeff Smith, product manager for SQL Developer. That should explain what you need to do.

Edited to add picture of the relevant options.

StackExchange Database Administrators Q#106892, answer score: 7