CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
user232627
user232627

Reputation: 2791

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

Upvotes: 279

Views: 120898

Answers (3)

Nathan
Nathan

Reputation: 3190

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.

Upvotes: 9

Jerome Dalbert
Jerome Dalbert

Reputation: 10405

You can pin a tab by clicking the button below :

Tab pin button

No need to configure anything, plus sometimes you don't want to have a tab automatically pinned.

Upvotes: 299

a70m
a70m

Reputation: 3539

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

Upvotes: 353

Related Questions