怎样用SQL语句把某个表里的字段都列出来?该怎么解决

怎样用SQL语句把某个表里的字段都列出来??
SQL-SERVER我知道,oracle的没用过..

------解决方案--------------------
或者
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
------解决方案--------------------
owner= 'user '
user也要大写的
------解决方案--------------------
select owner,column_name,data_type,data_length from dba_tab_columns
where owner= 'WINSTARHOUSEMARKET ' and table_name= 'BID_LINK '
其中：WINSTARHOUSEMARKET是所查表所在全权限的用户名