DBA Table Columns

➜ Back to Library
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
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 NameSQL textValidation
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 ONT Order Upload CAC Material Account Summary FND Audit Items FND Audit Table Changes by Column FND Forms Personalizations DBA AWR Active Session History
Blitz Report™