Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 583
Ali Avatar asked Mar 30 '12 00:03

Ali


People also ask

How do I open a SQL worksheet in Oracle SQL Developer?

One unique feature available in SQL Developer is to open up SQL worksheets in unshared mode. Click the Unshared SQL Worksheet icon or use the shortcut is CTRL + SHIFT + N. to open it.

How do I change the view in Oracle SQL Developer?

To redefine a view, you must use CREATE VIEW with the OR REPLACE keywords. When you issue an ALTER VIEW statement, Oracle Database recompiles the view regardless of whether it is valid or invalid. The database also invalidates any local objects that depend on the view.


2 Answers

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

like image 84
milso Avatar answered Sep 20 '22 22:09

milso


  1. Clicking or double-clicking on a table or view name in a worksheet does not open it up. You can, however, right click on the table name and choose either "Popup Describe" or "Open Declaration". "Popup Describe" can also be invoked by hitting Shift-F4 (at least on Windows. Based on the comments, it may be different on Mac OS).
  2. I don't believe there is a way to override the behavior of the single click when you Connections tree control. A single click always opens the declaration of the object.
like image 40
Justin Cave Avatar answered Sep 20 '22 22:09

Justin Cave