oracle-sqldeveloperibexpert

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


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.


Solution

  • 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