ThatJeffSmith

Tag: formatter

SQL Developer Formatter: Left Aligning Columns in a SELECT

Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going […]

Preserving Line Breaks in Oracle SQL Developer 4

Ugly code, we all write it. I don’t mean bad code either, just hard to read code. Developers who haven’t figured out how to use the TAB and ENTER keys – what’s up with that? — and why is Jeff talking to himself in his Seinfeld voice again? So one of the features in SQL […]

Formatting Keywords to UPPERCASE In Oracle SQL Developer

I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging How do I go FROM: TO It’s all in the formatting You need to access the formatting preferences […]