oracle中可不可以返回表的字段名啊？ 好像没见人干过:)

Question

DBA帐号：查看所有表名：
select * from all_tables;查看所有表结构：
select * from all_tab_columns;查看所有含约束字段及对应约束名：
select * from all_cons_columns;查看所有字段注释：
select * from all_col_comments;

Answer 1

SQL> create user mytemp identified by xyz
  2  temporary tablespace temp
  3  default tablespace users;用户已创建SQL> grant select any table to mytemp;授权成功SQL> select * from all_tab_columns;－－－－－－－－－－－
以上是可使用该视图权限，该权限可selectS实例中所有表和视图SQL> grant resource to mytemp;
SQL> select * from tab;----------------------
当前用户可使用资源，如表、视图、同义词等

Answer 2

查看所有表结构：
select * from all_tab_columns;--------------
根据上述视图all_tab_columns，你可以查看其结构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－－－－－－－－－－－－
其中owner为所有者，table_name为表名，根据上述条件SQL>select * from all_tab_columns
 2  where owner='MYUSER'
 3    and table_name='MYTABLE'