如何使用SQL Developer在指定Schema中查询特定列（如description列）

Hey there, let's break down how to locate columns named description (or any specific column name you're targeting) within a given schema using SQL Developer. I'll cover both a SQL-based approach (super flexible) and the GUI method for those who prefer point-and-click:

Method 1: Use a SQL Query (Most Efficient) #

This is my go-to because it gives you all the details at once without clicking around. We'll leverage Oracle's data dictionary views to pull the info:

-- Replace 'YOUR_TARGET_SCHEMA' with the actual schema name you're querying
SELECT 
  table_name, 
  column_name, 
  data_type,
  data_length
FROM all_tab_columns
WHERE 
  owner = 'YOUR_TARGET_SCHEMA'
  AND UPPER(column_name) = 'DESCRIPTION'; -- Use UPPER() to make it case-insensitive (adjust if your DB is case-sensitive)

Notes on this query: #

• If you're working within your current logged-in schema, swap all_tab_columns for user_tab_columns and remove the owner condition—it's faster and doesn't require extra permissions.
• If you need to see all columns across all schemas (and have DBA-level access), use dba_tab_columns instead.
• If your database uses case-sensitive identifiers (uncommon but possible), remove the UPPER() and match the exact column name (e.g., column_name = "Description" with double quotes).

Method 2: SQL Developer GUI Point-and-Click #

If you'd rather avoid writing SQL, here's how to do it via the interface:

• Open SQL Developer and connect to your target database.
• In the left-hand Connections panel, expand your target schema, then find the Tables node.
• Right-click on Tables and select Filter... from the menu.
• In the filter window, switch to the Columns tab.
• In the Column Name field, type description (or your target column name) and click Apply.
• The Tables list will now only show tables that contain your target column—you can expand any table to view the column's details directly.

Quick Tips #

• If you get a permission error when using all_tab_columns, ask your DBA to grant you SELECT access to that view, or stick with user_tab_columns for your own schema.
• For recurring searches, you can save the SQL query as a snippet in SQL Developer for quick access later.

内容的提问来源于stack exchange，提问作者soss.1033