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…

thatjeffsmith
Author

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

2 Comments

    • thatjeffsmith

      Those are just spaces..need at least one so for when I add the columns they don’t run into the SELECT

Write A Comment