dynamic query
Sunny, December 10, 2020 - 4:37 am UTC
select s.COLUMN_NAME || case
when max(s.COLUMN_ID) over() != s.COLUMN_ID then
' is null or '
else
' is null '
end output
from user_tab_columns s
where s.TABLE_NAME = 'TABLE_NAME'
order by s.COLUMN_ID;
after write " select * from table_name where " and put above code output here
December 11, 2020 - 3:16 am UTC
SQL to generate SQL is of course a valid option to use