Oracle SQL Developer multiple table views

oracle oracle-sqldeveloper
user232627 picture user232627 · Dec 16, 2009 · Viewed 87.9k times · Source

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

Answer

a70m picture a70m · Dec 22, 2009

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

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More