求sql语句。显示表中的所有字段用什么sql语句

Question

select * from user_tables

Answer 1

select cname,coltype,width from col where tname=upper('tbname');

Answer 2

select * from col where tname=upper('TABLENAME');
简单点使用desc tablename

Answer 3

不懂！我也想用sql语句找出多个表中含有某一特定字段的表

Answer 4

SQL> SELECT TABLE_NAME,COLUMN_NAME
  2  FROM ALL_TAB_COLUMNS
  3  WHERE TABLE_NAME ='BAO_TEMP'
  4  /TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------
BAO_TEMP                       ST_ID
BAO_TEMP                       CYC_TIME
BAO_TEMP                       CAPACITY
BAO_TEMP                       OWNER
BAO_TEMP                       MOVE_TIME

Answer 5

找出多个表中含有某一特定字段的表
SQL> SELECT TABLE_NAME,COLUMN_NAME
  2  FROM ALL_TAB_COLUMNS
  3  WHERE COLUMN_NAME = 'CYC_TIME'
  4  /TABLE_NAME                     COLUMN_NAME
------------------------------ -----------------
AVG_CYCLE_TIME_TEMP            CYC_TIME
BAO_TEMP                       CYC_TIME
PCSHD_PARAM_CONF               CYC_TIME

Answer 6

select cname from col where tname = upper('表名')