Beautifier - Table/Object Names lowercase

[BrianGee]

Hello everyone.

I'm new to these forums and also the whole SQL world! I'm using PL/SQL Developer but I'm having problems with my Beautifier.

I want to make all commands upper case but all the table/field/object names lowercase. Is there anyway I can amend the rules file to incorporate this?

This is how it looks now:

JOIN MEMBERSHIP_STATUS MS ON MS.MEMBERSHIP_STATUS_ID = M.MEMBERSHIP_STATUS_ID

This is how I want it to look:

JOIN membership_status ms ON ms.membership_status_id = m.membership_status_id

I hope someone can be of some assistance.

Thanks

 

[Gustavo]

Hi,

Welcome to the crew!

On the Beautifier options screen, set "Syntax Case Keywords" to "Uppercase" and "Syntax Case Identifiers" to "Lowercase".

Regards,
Gustavo

 

[BrianGee]

Thanks Gustavo. You're a star!