SQl Developer Single Query result tab please

oracle-sqldeveloper
Kaushik Gopal picture Kaushik Gopal · Feb 16, 2010 · Viewed 72.7k times · Source

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.

Answer

ROMANIA_engineer picture ROMANIA_engineer · Jul 31, 2015

SQL Developer 4.0 (2013)

  1. Close all the Query Result tabs

    enter image description here

  2. Tools > Preferences

    enter image description here

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

    enter image description here

Related questions

How to Execute SQL Server Stored Procedure in SQL Developer?

I've been given a user account to a SQL Server database that only has privileges to execute a stored procedure. I added the JTDS SQL Server JDBC jar file to SQL Developer and added it as a Third Party JDBC …

Read More
How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More