或者 select column_id, column_name, data_type, data_length, data_precision, data_scale,nullable,data_default from user_tab_columns where table_name = 'Tablename' order by column_id
select column_id,column_name,data_type,data_length,data_precision,data_scale,nullable,data_default from user_tab_columns where table_name = 'bid_link' order by column_id列不出来嘛
select column_name,data_type,data_length from dba_tab_columns where owner='user' and table_name='table' 需要其他字段的话,看看dba_tab_columns的结构就可以了
select column_name,data_type,data_length from dba_tab_columns where owner='user' and table_name='bid_link'还是没列出来,我连的别人的数据库
select column_name,data_type,data_length from dba_tab_columns where owner='user' and table_name='BID_LINK'也不行的说
owner='user' user也要大写的
select owner,column_name,data_type,data_length from dba_tab_columns where owner='WINSTARHOUSEMARKET' and table_name='BID_LINK' 其中:WINSTARHOUSEMARKET是所查表所在全权限的用户名
desc tablename
select column_id, column_name, data_type, data_length, data_precision, data_scale,nullable,data_default from user_tab_columns where table_name = 'Tablename' order by column_id
需要其他字段的话,看看dba_tab_columns的结构就可以了
user也要大写的
where owner='WINSTARHOUSEMARKET' and table_name='BID_LINK'
其中:WINSTARHOUSEMARKET是所查表所在全权限的用户名
desc tablename
这是最好的方法