How to find column name in table

Question

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

Answer 1

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.

Answer 2

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.