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'