SQl Developer Single Query result tab please

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 q开发者_开发技巧uery result windows to just one (Toad style). If there's a shortcut key for this, that would be super awesome.

SQL Developer 4.0 (2013)

1. Close all the Query Result tabs

   

2. Tools > Preferences

   

3. Database > Worksheet > uncheck "Show query results in new tabs"

   

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.

Instead of "Run Statement" click on "Run Script"(F5). This would give the output of two queries in the same Query Result window.

Directly to the database or from an application? Do you mean returning one result set from multiple tables together or multiple result sets in one pane? Are you using SQL 2000, 2005, 2008, or something else? The question is vaguely worded, but I'll try to help anyway.

For the purposes of this answer, I think you're trying to query the database directly. Open SQL Server Management Studio 2005 or newer (Not sure if this works in 2000), click New Query, and type the multiple queries into the pane. i.e.:

select * from table1
select * from table2

will return two result sets in the same window/pane.

Unpin helps keep current tab for next query.

(I am using Oracle SQL Developer 22.x)

I found that this was happening in SQL Dev v4.0.2.15 because I was running 2 SELECT statements. Running one SELECT at a time re-used the Results tab.