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
SQL 15 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Column Name contains | Char |
| |
| Table Name starts with | LOV |
| |
| Exclude Views | LOV |
|