Oracle SQL Developer multiple table views
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd
the problem is that we often really need to view more than one table at once, then we need more than one tab opened, thing that i dont know how to do that, any sugestion. tq in advance
SQL Developer can start a new tab every time you select a database object to view; but, you will have to close the tab manually.
Set this in: Tools->Preferences->Database->ObjectViewer->Automatically Freeze Object Viewer Windows
You can pin a tab by clicking the button below :
No need to configure anything, plus sometimes you don't want to have a tab automatically pinned.
Jeff Smith posted a nice write up on how to do this in SQL Developer.
There are multiple ways to do it.
Freeze content (ctrl-shift-P)
New Document Tab Group (will allow viewing tables simultaneously)
Change the preferences (If this is desired default behavior)
The post can be found here.
Follow WeChat
Success story sharing
Want to stay one step ahead of the latest teleworks?
Subscribe Now相似问题
- Get list of all tables in Oracle?
- How do I limit the number of rows returned by an Oracle query after ordering?
- How can I find which tables reference a given table in Oracle SQL Developer?
- Oracle SQL Developer - Query results window with grid missing
- How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- How to create a new database after initally installing oracle database 11g Express Edition?
