Menu
In the free application SQL-Developer (provided by Oracle), I tried searching around for this but couldn't immediately find a solution. I find the opening of multiple SQL query result window/tabs mildly annoying. I'm sure there are very useful cases for this feature, but my question is: Can we turn the multiple query result windows to just one (Toad style). If there's a shortcut key for this, that would be super awesome.
859
You can toggle a setting to "Show query results in new tabs" under Tools -> Preferences... -> Database -> Worksheet, so if you have all queries highlighted and Click F9 (Run), then each query result appears in a new grid tab.
You have the option of displaying your query results on the Run SQL window, as opposed to Data Display windows. To do this, go to View > Data Grid (Ctrl+G). Once you have selected this option, a panel will appear at the bottom of the window - your query results will be displayed there.
The single record view occurs in a couple of places. This includes selecting a table in the list and then selecting the data tab. Then right click on a record. This does not require writing any SQL.
Just keep opening worksheets, right-click on a connection, or use Tools > SQL Worksheet, the toolbar buttons, or ctrl+shift+n. Each worksheet is it's own document. You can create multiple document tab groups if you want to see and work on multiple worksheets concurrently.
SQL Developer 4.0 (2013)
Close all the Query Result tabs
Tools > Preferences
Database > Worksheet > uncheck "Show query results in new tabs"
56
So, it turns out this is a bug. If you look closely, you'll notice that for each query run, your results tab is automatically being pinned, causing each new query run to need it's own new tab to display the results.
The automatic pinning is only supposed to be enabled when you explicitly go into Tools->Preferences->Database->Worksheet->"Automatically Freeze Result Tabs".
It is an identified bug, that Oracle fixed with SQL Developer 2.1.1.
Go to oracle.com and download the latest version and this should go away. It was definitely very annoying.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
