Get the Right Columns, In the Right Order

thatjeffsmith SQL Developer 2 Comments

Tell Others About This Story:

Some of you are real fast typers, and don’t need this type of help.

However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general.

So let’s say you’re working on a report, and the column order is very specific.

Now, you could use the INSIGHT/POPUP feature, but those names come back in alpha order.

The columns will be added to the query in the order as shown in the popup window.

Or you could just call that feature once for every column you need to add, but that would get old quickly for me.

So here’s another alternative. Use your mouse.

Click, click, click, drag, drop. Done.

So in the tree, if you click on 5 things, and drag them over to an editor, and drop them – the names will be pasted in the order in which you clicked them.

This isn’t just for columns of course, but it’s probably the only use case where this feature has real value. Hopefully you’re not querying 7 table or views…

Related Posts

Tell Others About This Story:

Comments 2

    1. thatjeffsmith Post

Leave a Reply

Your email address will not be published. Required fields are marked *