Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Oracle SQL Developer multiple table views

Tags:

oracle

oracle-sqldeveloper

People also ask

How do I open multiple windows in Oracle SQL Developer?

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

How do I open a duplicate tab in SQL Developer?

' Right click on the table editor tab and ask for the new document tab group. Voila.

Can views show data from multiple tables?

A view that combines data from multiple tables enables you to show relevant information in multiple tables together. You can create a view that combines data from two or more tables by naming more than one table in the FROM clause.

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 :

Tab pin button

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.

Related questions

How SID is different from Service name in Oracle tnsnames.ora
How do I reset a sequence in Oracle?
Oracle find a constraint
How do I turn off Oracle password expiration?
GROUP BY with MAX(DATE) [duplicate]
What's the difference between RANK() and DENSE_RANK() functions in oracle?
SQL Query to concatenate column values from multiple rows in Oracle
What is the difference between Non-Repeatable Read and Phantom Read?
How can I get column names from a table in Oracle?
When do I need to use a semicolon vs a slash in Oracle SQL?
What is the maximum length of a table name in Oracle?
What resources exist for Database performance-tuning? [closed]
How can I find which tables reference a given table in Oracle SQL Developer?
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
How can I set a custom date time format in Oracle SQL Developer?
Why does Oracle 9i treat an empty string as NULL?
Oracle Differences between NVL and Coalesce
What is the dual table in Oracle?
Case insensitive searching in Oracle
How to export query result to csv in Oracle SQL Developer?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!