Oracle:
SELECT table_name, column_name FROM user_tab_columns WHERE column_name = 'KSMC';
MySQL:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='数据库名' AND COLUMN_NAME='字段名'
Oracle:
SELECT table_name, column_name FROM user_tab_columns WHERE column_name = 'KSMC';
MySQL:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='数据库名' AND COLUMN_NAME='字段名'