/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

0 vote358 views1 answer
How to to get current date in sql
SQL
0 vote375 views1 answer
Stored procedures example
SQL
0 vote368 views1 answer
Duplix print in Smartforms
SQL
5 votes383 views3 answers
Postgres show databases
SQL
1 vote338 views1 answer
Base nosql
SQL
0 vote339 views1 answer
View acl table oracle
SQL
2 votes340 views2 answers
Sqlite_busy: database is locked
SQL
16 votes396 views6 answers
Mysql find duplicates in same table
SQL
2 votes350 views1 answer
Add default sql server
SQL
0 vote353 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL