select * from user_tables a,DBA_TAB_COLUMNS b where a.tablename=b.tablename and b.columns ='列名' and a.tablename ='表名'
select * from user_tables a,DBA_TAB_COLUMNS b where a.TABLE_NAME=b.TABLE_NAME and b.column_name ='NAME' and a.TABLE_NAME ='COURSES'表COURSES 列 COURSEID,NAME 注意上面and b.column_name ='NAME' and a.TABLE_NAME ='COURSES' 条件判断中NAME,COURSES必须为大写
cols 为 DBA_TAB_COLUMNS
where a.tablename=b.tablename
and b.columns ='列名'
and a.tablename ='表名'
where a.TABLE_NAME=b.TABLE_NAME
and b.column_name ='NAME'
and a.TABLE_NAME ='COURSES'表COURSES 列 COURSEID,NAME
注意上面and b.column_name ='NAME' and a.TABLE_NAME ='COURSES' 条件判断中NAME,COURSES必须为大写