/SQL/Select only columns that are not empty oracle sql

Select only columns that are not empty oracle sql

select COLUMN_NAME
from sys.all_tab_columns col
inner join sys.all_tables t on col.owner = t.owner 
                              and col.table_name = t.table_name
where 
col.table_name = 'SHRDGMR'
AND (NUM_DISTINCT > 0 or density > 0)
order by col.column_id;

Select only columns that are not empty oracle sql

select COLUMN_NAME
from sys.all_tab_columns col
inner join sys.all_tables t on col.owner = t.owner 
                              and col.table_name = t.table_name
where 
col.table_name = 'REPLACE THIS WITH YOUR TABLE NAME'
AND NUM_DISTINCT > 0 
order by col.column_id;

Similar codes

3 votes249 views1 answer
Sql select all
SQL
0 vote257 views1 answer
Sql server python connection
SQL
1 vote275 views1 answer
Too many connections mysql
SQL
1 vote253 views2 answers
Postgresql list columns
SQL
13 votes268 views1 answer
Sql join 3 tables on id
SQL
15 votes267 views6 answers
Drop foreign key mysql
SQL
0 vote242 views1 answer
Is not null postgresql
SQL
0 vote262 views1 answer
Search In the Data using ObjectName
SQL
2 votes240 views1 answer
Oracle sql drop column if exists
SQL
4 votes231 views1 answer
Install postgres 12 on ubuntu
SQL