DBA Table Columns

Description
Categories: Enginatics
Repository: Github Columns: Owner, Table Name, Column Name, Data Type, Nullable, Column Id ...
Report with all table column names based on dba_tab_columns, as finding tables by column names is a frequent task during SQL development
select
dtc.owner,
dtc.table_name,
dtc.column_name,
dtc.data_type||case when dtc.data_type like '%CHAR%' then ' ('||dtc.data_length||')' end data_type,
decode(dtc.nullable,'N',xxen_util.meaning(dtc.nullable,'YES_NO',0)) nullable,
dtc.column_id
from
dba_tab_columns dtc
where
1=1
order by
dtc.owner,
dtc.table_name,
dtc.column_id
Parameter Name SQL text Validation
Exclude Views
(dtc.owner, dtc.table_name) in (select dt.owner, dt.table_name from dba_tables dt)
LOV
Column Name contains
lower(dtc.column_name) like '%'||lower(:column_name)||'%'
Table Name starts with
lower(dtc.table_name) like lower(:table_name)||'%'
LOV