In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you.

I'm trying to type here!
I’m trying to type here!

A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4…

If You Want Help, Ask For It!

Use the keyboard to activate the 'help.'
Use the keyboard to activate the ‘help.’

So what’s the magic key sequence?

It’s the same as in the worksheet when activating the Code Insight feature.

Ctrl+Spacebar

And we fixed a persnickety bug while we were at it…when using the history list to pop a filter in, after clicking it into the form, the initial search text be appended with the filter text instead of replaced.

That’s finally fixed for our next EA build.

Yuck - this is finally fixed :)
Yuck – this is finally fixed 🙂

I Know I’m Weird

Why make such a big deal out of such a little thing? I know I drive some people nuts with my opinions. It’s my opinion that little features like this are where people LIVE in the tool. If you’re looking at data all day, let’s do our best to make that as pleasant as possible. So whilst we might break things or change things or build new things that you don’t like, please remember our goal is to always make things ‘better.’

If you think this particular change is wrong, we still have time to ‘fix’ it for version 4, so don’t be shy!

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.

8 Comments

  1. Jeff, thank you for this fix. I use Ctrl+Spacebar all the time. Love it.

    Q: is there a way to grab the sql that gets generated? I don’t see e.g. a right click for this.

    • It’s just a select * from with your where clause.

      If you go to View – Log – Statements, you’ll get every SQL we run for you.

    • julesdba

      I see the statement. Thank you. However, if I choose to Show only certain columns, that query under Statements still includes all columns.

    • Right, because we don’t use SQL to hide the columns.

      It kind of sounds like to me you might want to try the query builder.

  2. Well done Jeff & co … finally the fix made it after such a long time.

    Thanks again to all!!

  3. Awesome! – it’s little tips like this which make me love SQL Developer all the more. Thanks for bringing things like this to our attention. Keep up the great work!

Reply To Nigel Richmond Cancel Reply