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?
Add a comment
|
3 Answers
- You can right click on a connection and chose 'Open SQL Worksheet' it will create another window for the existing session.
- 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.
Comments
In preferences, go to Database > ObjectViewer and check the Automatically Freeze Object Viewer Windows checkbox.
1 Comment
victorien sukarieh
on connection channel i right clicked the DB pressed open SQL Worksheet and it gave me a new instance
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.
1 Comment
mrun
Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker.