select TNAME from tab ;
得到表名
select column_name,DATA_TYPE from user_tab_columns where table_name=upper('表名')得到列名就行了还可看看 desc user_tab_columns
得到表名
select column_name,DATA_TYPE from user_tab_columns where table_name=upper('表名')得到列名就行了还可看看 desc user_tab_columns
select cname from col where tname='TABLENAME';
select column_name from user_tab_columns where table_name='TABLENAME';
select column_name from ALL_tab_columns where table_name='TABLENAME';
select column_name from dba_tab_columns where table_name='TABLENAME';
select column_name from user_col_comments where table_name='TABLENAME';
select column_name from all_col_comments where table_name='TABLENAME';
select column_name from dba_col_comments where table_name='TABLENAME';