A follower reached out to me late yesterday with this request:
And the answer is yes, we can pretty much get there.
I’ve noticed a few things by looking at his hand-formatted code on the bottom section.
- everything lowercase
- right-aligned keywords
- no line breaks for the sub query ()’s
- no line breaks after SELECT/FROM/WHERE keywords
So let’s go tell the formatter to follow these same rules.
Note that all other formatter preferences are left to DEFAULT values.
Now, let’s format the code.
For those of you following along, here’s the code so you can try to replicate what we’re showing:
SELECT owner, TABLE_NAME FROM all_tab_columns WHERE column_name = 'EMPLID' AND TABLE_NAME IN ( SELECT DISTINCT referenced_name FROM all_dependencies WHERE name IN ( SELECT object_name FROM all_objects WHERE object_type = 'FUNCTION' AND owner = 'OBI_DW' ) AND referenced_type = 'TABLE' );
A Couple of Parting Notes
I’m happy to help you get your formatting preferences, just right. But, YOU can also do most of this on your own.
Let’s go back into the formatter preferences for a second.
This was done with version 18.2. There is a wee bug with the RIGHT ALIGN KEYWORDS preference. It MOSTLY works, but it’s off a few characters. This is fixed for version 18.3.
So, did we get to where our friend wanted? I think we’re VERY close.