1、在数据库表中查找 表名包含‘GIS_ZHZY’这个表
select 'drop table '||table_name||';' from user_tables where table_name like '%GIS_ZHZY%';
2、在GIS_ZHZY_QY_P表中查找列名包含‘投资’的列
SELECT * FROM user_tab_columns WHERE TABLE_NAME='GIS_ZHZY_QY_P' and column_name like '%投资%';
select 'drop table '||table_name||';' from user_tables where table_name like '%GIS_ZHZY%';
2、在GIS_ZHZY_QY_P表中查找列名包含‘投资’的列
SELECT * FROM user_tab_columns WHERE TABLE_NAME='GIS_ZHZY_QY_P' and column_name like '%投资%';