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.
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With