snir.tur
snir.tur

Reputation: 451

How to find column name in table

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

enter image description here

Upvotes: 7

Views: 35742

Answers (7)

Amrutesh Mishra
Amrutesh Mishra

Reputation: 11

  1. You can view the table by expanding the Connections option in the Left Hand Pane. Then Navigate to the table and Click on it.

  2. This will open the Table View.

  3. Then select the Column Name here and it will provide an option to search with Column Names

Connections

Upvotes: 0

Dark lord
Dark lord

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.

dbeaver search

Upvotes: 1

thatjeffsmith
thatjeffsmith

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.

enter image description here

Upvotes: 3

Du-Lacoste
Du-Lacoste

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

Shafi
Shafi

Reputation: 1970

  1. Right click on your connection name.
  2. Then click "Find DB Object" on the context menu.
  3. It will take you to a textbox. Write your column name
  4. And check the box with "Columns".
  5. Then press "enter" or click on "Go".

Then sqldeveloper will search your column and will show you the result [ column name with table name].

Upvotes: 0

Paul
Paul

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

Giggs
Giggs

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

Related Questions