CODEWITHSUNDEEP
oracle-sqldeveloper
victorien sukarieh
victorien sukarieh

Reputation: 93

Multiple Window Oracle SQL Developer

I am using SQL developer to access 2 different databases. I have 2 connections and while working I need to open multiple windows for each database.

How does one do that?

Upvotes: 6

Views: 15988

Answers (3)

Ruben Sebastian
Ruben Sebastian

Reputation: 181

dbardelas answer helped me, the only thing is that he missed where is Database.

Database can be found in tools -> preferences

I had similar issue as victorien sukarieh the only issue I had is that every conexion to a table or database was opened on top of the previous one. It didn't let me visualize multiple tables, with the answer of dbardelas I can open multiple table visualization.

Upvotes: 0

hemalp108
hemalp108

Reputation: 1249

  1. You can right click on a connection and chose 'Open SQL Worksheet' it will create another window for the existing session.
  2. Use Alt + F10and select the connection from the list.

If you need to create another independent session you can use Ctrl + Shift + N for an ongoing session.

Upvotes: 9

dbardelas
dbardelas

Reputation: 404

In preferences, go to Database > ObjectViewer and check the Automatically Freeze Object Viewer Windows checkbox.

Upvotes: 4

Related Questions