select 'Alter table ' || table_name || ' modify COLUMN ' || column_name || ' float;' From all_tab_columns

where table_name in (

SELECT * FROM (

SELECT OBJECT_NAME FROM DBA_OBJECTS

WHERE OWNER IN

('SACMSCMMRI','SACMSIDS','SACMSWPS','SACMSRDM','SACMSTAB','SCFRDTAB')

AND OBJECT_TYPE IN

('TABLE')

AND OBJECT_NAME NOT LIKE '%$%'

ORDER BY OWNER, OBJECT_NAME )

)

AND owner in ('SACMSCMMRI','SACMSIDS','SACMSWPS','SACMSRDM','SACMSTAB','SCFRDTAB') and data_type='NUMBER'