How to find column name in table

oracle-sqldeveloper dbeaver
snir.tur picture snir.tur · Dec 21, 2015 · Viewed 16.3k times · Source

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

Answer

Paul picture Paul · Dec 21, 2015

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.

Related questions

How to Execute SQL Server Stored Procedure in SQL Developer?

I've been given a user account to a SQL Server database that only has privileges to execute a stored procedure. I added the JTDS SQL Server JDBC jar file to SQL Developer and added it as a Third Party JDBC …

Read More
How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More