select 'Alter table ' || table_name || ' modify COLUMN ' || column_name || ' float;' From all_tab_columnswhere table_name in (SELECT * FROM (SELECT OBJECT_NAME FROM DBA_OBJECTSWHERE OWNER IN('SACMSCMM