oracle查询包含某个字段的表:
select table_name from user_tab_cols where column_name = 'xxx'
oracle查询包含某个类型为VARCHAR2并且长度为30的字段的表
select count(table_name) from user_tab_cols where column_name = 'CABINET_ID' AND data_type='VARCHAR2'
AND DATA_LENGTH=30
要修改,可以先运行以下语句:
SELECT 'alter table '||owner||'.'||table_name||' modify ( '||Column_name ||' float (100));'
FROM DBA_TAB_COLUMNS
WHERE owner='用户名'
AND data_type='FLOAT'
AND DATA_LENGTH=30;
From:http://hi.baidu.com/%B2%BB%D6%AA%CE%E8%D5%DFlily/blog/item/da045e18dc94a54b43a9add6.html