DBA Table Columns

Description
Categories: Enginatics
Repository: Github
Report with all table column names based on dba_tab_columns, as finding tables by column names is a frequent task during SQL development

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Column Name contains
lower(dtc.column_name) like '%'||lower(:column_name)||'%'
Char
Table Name starts with
lower(dtc.table_name) like lower(:table_name)||'%'
LOV
Exclude Views
(dtc.owner, dtc.table_name) in (select dt.owner, dt.table_name from dba_tables dt)
LOV