Oracle SQL Developer, how to open table/view by clicking/double clicking on its name in worksheet?

oracle-sqldeveloper ibexpert
Ali picture Ali · Mar 30, 2012 · Viewed 25.1k times · Source

The Oracle SQL developer is what I use these days and it is missing some of my previous tool (IB Expert, great tool by the way) functionalities.

1.How is it posible in SQL Developer to open table/view by click/double click on its name in the worksheet.

2.Clicking on a table/view name under its connection will open the table next to already opened worksheets or SQL files. How could this changed to double click instead?

I am using SQL Developer Version 3.0.04 under Mac OS X 10.6.8.

I have upgraded SQL Developer to the latest(Version 3.1.07) and still have the same issue.

Answer

milso picture milso · Oct 12, 2012

How to override Single Click to Open tables (or any other object in tree view) Tools > Preferences > ObjectViewer > Uncheck Open Object on Single Click

Edit: For version 1.5.5 Tools > Preferences > Database > Advanced Parameter > Uncheck Open object on Single click

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