Reputation: 451
I'm trying to find a column in a very big table in ORACLE SQL Developer, its really difficult to find it visually.
Is there any easy way to find the column in the table?
For example, in DBeaver its just Tab and then Ctrl + f
Upvotes: 7
Views: 35742
Reputation: 11
You can view the table by expanding the Connections option in the Left Hand Pane. Then Navigate to the table and Click on it.
This will open the Table View.
Then select the Column Name here and it will provide an option to search with Column Names
Upvotes: 0
Reputation: 11
On toolbar, Click View->Find DB Object Now select the connection, the type and which column the value has to be found in. (NAME,TYPE AND USAGE(ALL)) The tables are displayed, select the table to view the columns having the field you are searching for.
Upvotes: 1
Reputation: 22467
There is no search feature in the SQL Developer data grids for finding/navigating to a specific Column, but I'll add that as a feature request.
You may find the Single Record View handy for browsing very WIDE records.
Upvotes: 3
Reputation: 12827
I would prefer writing a query is more faster compared to IDE provided buttons and clicks.
If so this would work out.
Use the following.
You can try this via SQL tool that is used by you
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';
Or if you have DBA privileges,
select table_name from dba_tab_columns where column_name = 'PICK_COLUMN';
But if you are not sure about the column names you can add LIKE
statements to current query.
Eg:
select table_name from all_tab_columns where column_name LIKE '%PICK_COLUMN%';
Upvotes: 2
Reputation: 1970
Then sqldeveloper will search your column and will show you the result [ column name with table name].
Upvotes: 0
Reputation: 1167
Oracle has an awesome data dictionary. Most of the time it will be even faster to write a query that accesses some of its views than use IDE features.
You can get columns from view ALL_TAB_COLUMNS
.
SELECT *
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = :your_table_name
AND COLUMN_NAME LIKE '%YOUR_SEARCH_STRING%'
As for SQL Developer, you can open table from your connections tree, go to Columns tab and just use Edit -> Find (Ctrl/Cmd + F). Works for me in 4.0.2.15.
Upvotes: 9
Reputation: 77
Right click on column header in the data grid, then you have a menu Columns where you can filter columns you want to display
Upvotes: 0