SQL Window enhancement

[Edwin Teisman]

I would like to see two features added to the SQL Window:

1. An Shortcut key with which I can quickly navigate from the query result records back to the sql above this.
Currently if I decide to modify the SQL used, it requires me to hange the focus using my mouse.
As an experienced programmer I am very keyboard focussed.

2. The SQL part of the SQL window becomes 3 lines
high if the sql is a one-line query like
"select * from table"
If there any way so I can change this default to a minimum of say 12 lines or more?
I have an 22 inch screen so I have space enough.
Now I am very often required to resize the sql window, using my mouse.

Both these features would be handy because I very ofter write some SQL, try it, change it, try it again, etc.

By the way, great tool!

(*PLSQLDev version 7.0.1.1066*)

 

[Marco Kalter]

1. An Shortcut key with which I can quickly navigate from the query result records back to the sql above this.
Currently if I decide to modify the SQL used, it requires me to hange the focus using my mouse.
As an experienced programmer I am very keyboard focussed.

Go to Tools > Preferences > Key configuration and assign a key to "SQL Window: switch between editor/results".

2. The SQL part of the SQL window becomes 3 lines
high if the sql is a one-line query like
"select * from table"
If there any way so I can change this default to a minimum of say 12 lines or more?

I have added this to the list of enhancement requests.

 

[Stew Stryker]

> If there any way so I can change this default to a minimum of say 12 lines or more?

I'd like to see this as well.

Looking at it from the opposite direction I think it's working now, I'd like to see it size the results window sized based on the query results.

• If the query returns NO rows, size it to just show a couple rows,
• If it returns 5 rows, just show 6 (so it's clear there are no more,
• If it returns lots more rows, expand to the max line preference setting.

Something like that.