想查出一个表中的所有字段名，搜了下原来的贴子，但查不出，为什么？

Question

TABLE_NAME=upper('你的表名')

Answer 1

ALL_TAB_COLUMNS 中存储了表名和对应的表的字段名的信息.全用大写.

Answer 2

1  select A.TABLE_NAME,A.COLUMN_NAME,A.DATA_TYPE from ALL_TAB_COLUMNS A
  2* WHERE A.TABLE_NAME='CM_PART_ST_MATERIAL_COST'
SQL> /TABLE_NAME                     COLUMN_NAME                    DATA_TYPE
------------------------------ ------------------------------ ------------
CM_PART_ST_MATERIAL_COST       PART_ID                        VARCHAR2
CM_PART_ST_MATERIAL_COST       ST_ID                          VARCHAR2
CM_PART_ST_MATERIAL_COST       SQU_NO                         NUMBER
CM_PART_ST_MATERIAL_COST       COST_CODE                      VARCHAR2
CM_PART_ST_MATERIAL_COST       COST_DES                       VARCHAR2
CM_PART_ST_MATERIAL_COST       NUM_WPNL                       NUMBER
CM_PART_ST_MATERIAL_COST       NUM_SPNL                       NUMBER
CM_PART_ST_MATERIAL_COST       NUM_PICS                       NUMBER
CM_PART_ST_MATERIAL_COST       AREA_WPNL                      NUMBER
CM_PART_ST_MATERIAL_COST       AREA_SPNL                      NUMBER
CM_PART_ST_MATERIAL_COST       AREA_PICS                      NUMBER首先語句是沒有錯的，用upper是最好的選擇

Answer 3

select * from user_col_comments where TABLE_NAME = '你的表名'(大写)