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 to get the questioner, and you, very close to what you’re looking for.

Set These Formatter Preferences

column_indent1

One comma per line. Line break before a comma. No line break after a comma.

align_columns2

Align on commas.

align_columns3

Indent 7 spaces.

Before Format

Hard to read
Hard to read

After Format

Easier to read
Easier to read

Is this perfect?

No. You’ll notice we’re hard coding the indentation point. So if your SELECT starts with a comment or hint, it won’t align exactly. But again, I’m trying to save you time based on what we have in the formatter today. Tomorrow, it would be ideal for the parser to supply the formatter the exact column position for alignment…stay tuned.

In version 4.1, you’ll have a bit easier time mass-tabbing columns in your text as well…

Multi-cursor support in version 4.1 #SneakPeek
Multi-cursor support in version 4.1 #SneakPeek
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

14 Comments

  1. Profiled in the “NOVA” episode airing immediately on PBS,
    Watson was born out associated with an IBM research lab and named after the
    company’s founder, Thomas Watson. Whirlpool cabrio dryer manual Before deciding your brand-new front load automatic washer’s rinse cycle is not working,
    refer for the manual and phone the manufacturer to aid troubleshoot the problem.

    Also, if your fabric softener reservoir ever clogs it makes an excellent mess and you should end up rewashing the clothes in case you don’t take the agitator apart and
    clean it. And the past aspect that actually determines if a washer is worth investigating, is whether or not you
    actually get a money’s worth.

  2. In manufacturing industry certain parts might be unsuitable for
    people due towards the gases or any other byproducts.
    Safe Eyes is just like a complete monitoring tool which helps you stay
    aware of what your complete child does, when online.
    Cctv warning signs Author : Shivakumar is CTO of ADISYS Online
    — Sourcing and Distribution Company in Electronic Security Products Vertical.

    But still you will discover many folks who have questions
    into their mind about why people utilize this camera.
    It have their local branches across United Kingdom and it likewise
    maintains close relationships using its erstwhile together with present customers.

  3. Monitoring the vicinity continuously can prevent such misfortunes.
    CCTV home security system technology and
    CCTV equipment might be used within internal and external environments to look at over and protect people, property,
    vehicles and valuables. Cctv jammer circuit There usually are not too many choices for you with
    regards to optimizing system using Webroot system
    optimizer tool.

    These also get treatment well in blocks of flats and are also often found
    here. There are a handful of good value CCTV kits available that you are
    able to install yourself and so are easy to manage.

  4. 事実上のリストラとしてひっそりと卒業させられたメンだよな
    移籍拒否することは別にいいと思う。それは運営が悪いんだし。
    大島は美人じゃないよw枕相手が相手を捜すんじゃないか

  5. 同じ職場の同僚が結婚して、披露宴にお呼ばれしたら3万 仙台ランチ買い物楽しかった~♪恋愛。婚活。人生迷う‥難しい!一番の幸せは?
    仙台ランチ買い物楽しかった~♪恋愛。婚活。人生迷う‥難しい!一番の幸せは? それは人間も動物の一種であることの証明だ。 結婚祝

    何時間も拘束されてマズい料理食わされてしょうもない引き出物持たされて、県内だと足代もかかるクソイベントに行きたい奴なんていねーから
    ここで1万でいいとか払いたくないとか言う奴、実行に移したりするなよ。 結婚祝いプレゼント兄弟
    結婚式は誘う側誘われる側、双方の常識が出るな。
    トモダチ、友情なんて、薄っぺらいもんさ。

  6. Hi Jeff,

    I searched your site for while now but couldn’t find what I was looking for.
    So here is my question: Is there a tag that lets me exclude parts of the code from being formatted?

    For example:

    some code
    — NoFormat Start
    some code which I format myself
    — NoFormat End
    rest of the code

  7. Yeah, hard-coded indentation… I remember I asked you a similar question, and after expermenting further I got to same solution… but alas, the indentation works the same for PL/SQL, and indenting every block with 7 spaces is NOT PRETTY, so I had to give up on that and still format everything manually. Well, there’s a plus side – it looks super-tidy when done by hand.

    As for multi-cursor – wow. No, WOW. That’s REALLY awesome, for me it’s on par with regular expression support in terms of usablilty as a code editor. What’s the key combination for doing that will be, alt+click? And I take it, it’ll be possible to move all cursors at the same time with arrows/home/end buttons and type not only spaces, but anything?

    • ctrl+shift+click to add a new cursor, yes you can type/whatever vs just spacing stuff out 🙂

  8. Multi-cursor, sweet! That’s one of my top go-to features in Notepad++. If SQL Developer is getting it too, then that’s a huge step forward. Is star expansion a current feature I’ve somehow missed or is that also new goodness to yet to come?

    • The star expansion has been in version 4 for awhile…look for the squiggle. Mouse over it..wait, then click on the bubble to expand the list.

    • I am using v. 4.0.3.16 but could not do the star expansion. I do not the squiggle. Is there an option that I need to enable in the Preferences? Thanks.

Write A Comment