DBA Table Columns

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
Run DBA Table Columns and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
Blitz Report VPD Policy Setup FND Audit Setup DBA Table Modifications FND Forms Personalizations FND Audit Items FND Audit Table Changes by Column XLA Distribution Links Summary DBA AWR SQL Performance Summary DBA AWR System Wait Event Summary
Blitz Report™

Blitz Report™ provides multiple benefits: