SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql FROM ALL_TAB_COLUMNS WHERE DATA_TYPE = 'DATE' and OWNER='PS_EXAMPLEDBUSER' order by COLUMN_NAME asc
SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql FROM ALL_TAB_COLUMNS WHERE DATA_TYPE = 'DATE' and OWNER='PS_EXAMPLEDBUSER' order by COLUMN_NAME asc