请问如何得知表结构

Question

SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME='你的表名';

Answer 1

  1* select object_name from all_objects where object_name like 'ALL_TAB%'
SQL> /
OBJECT_NAME
------------------------------
ALL_TABLES
ALL_TAB_COLUMNS
ALL_TAB_COL_STATISTICS
ALL_TAB_COMMENTS
ALL_TAB_HISTOGRAMS
ALL_TAB_MODIFICATIONS
ALL_TAB_PARTITIONS
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
ALL_TAB_SUBPARTITIONS
ALL_TABLES
ALL_TAB_COLUMNS
ALL_TAB_COL_STATISTICS
ALL_TAB_COMMENTS
ALL_TAB_HISTOGRAMS
ALL_TAB_MODIFICATIONS
ALL_TAB_PARTITIONS
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
ALL_TAB_SUBPARTITIONS已选择22行。SQL> desc ALL_TAB_COLUMNS
 名称                                     空?      类型
 ---------------------------------------- -------- ---------------------------
 OWNER                                    NOT NULL VARCHAR2(30)
 TABLE_NAME                               NOT NULL VARCHAR2(30)
 COLUMN_NAME                              NOT NULL VARCHAR2(30)
 DATA_TYPE                                         VARCHAR2(106)
 DATA_TYPE_MOD                                     VARCHAR2(3)
 DATA_TYPE_OWNER                                   VARCHAR2(30)
 DATA_LENGTH                              NOT NULL NUMBER
 DATA_PRECISION                                    NUMBER
 DATA_SCALE                                        NUMBER
 NULLABLE                                          VARCHAR2(1)
 COLUMN_ID                                NOT NULL NUMBER
 DEFAULT_LENGTH                                    NUMBER
 DATA_DEFAULT                                      LONG
 NUM_DISTINCT                                      NUMBER
 LOW_VALUE                                         RAW(32)
 HIGH_VALUE                                        RAW(32)
 DENSITY                                           NUMBER
 NUM_NULLS                                         NUMBER
 NUM_BUCKETS                                       NUMBER
 LAST_ANALYZED                                     DATE
 SAMPLE_SIZE                                       NUMBER
 CHARACTER_SET_NAME                                VARCHAR2(44)
 CHAR_COL_DECL_LENGTH                              NUMBER
 GLOBAL_STATS                                      VARCHAR2(3)
 USER_STATS                                        VARCHAR2(3)
 AVG_COL_LEN                                       NUMBER

Answer 2

显示表结构
desc 表名;

Answer 3

谢了，二位！
楼上的，对不起，DESC 在应用程序中用不了！