oracle desc 表结构

  1 SQL> desc v$logfile;
  2  名称                                      是否为空? 类型
  3  ----------------------------------------- -------- ------------------
  4 
  5  GROUP#                                             NUMBER
  6  STATUS                                             VARCHAR2(7)
  7  TYPE                                               VARCHAR2(7)
  8  MEMBER                                             VARCHAR2(513)
  9  IS_RECOVERY_DEST_FILE                              VARCHAR2(3)
 10 
 11 
 12 SQL> desc V$log;
 13  名称                                      是否为空? 类型
 14  ----------------------------------------- -------- ----------------------
 15 
 16  GROUP#                                             NUMBER
 17  THREAD#                                            NUMBER
 18  SEQUENCE#                                          NUMBER
 19  BYTES                                              NUMBER
 20  MEMBERS                                            NUMBER
 21  ARCHIVED                                           VARCHAR2(3)
 22  STATUS                                             VARCHAR2(16)
 23  FIRST_CHANGE#                                      NUMBER
 24  FIRST_TIME                                         DATE
 25 
 26 
 27 
 28 SQL> desc V$datafile;
 29  名称                                      是否为空? 类型
 30  ----------------------------------------- -------- ----------------------
 31 
 32  FILE#                                              NUMBER
 33  CREATION_CHANGE#                                   NUMBER
 34  CREATION_TIME                                      DATE
 35  TS#                                                NUMBER
 36  RFILE#                                             NUMBER
 37  STATUS                                             VARCHAR2(7)
 38  ENABLED                                            VARCHAR2(10)
 39  CHECKPOINT_CHANGE#                                 NUMBER
 40  CHECKPOINT_TIME                                    DATE
 41  UNRECOVERABLE_CHANGE#                              NUMBER
 42  UNRECOVERABLE_TIME                                 DATE
 43  LAST_CHANGE#                                       NUMBER
 44  LAST_TIME                                          DATE
 45  OFFLINE_CHANGE#                                    NUMBER
 46  ONLINE_CHANGE#                                     NUMBER
 47  ONLINE_TIME                                        DATE
 48  BYTES                                              NUMBER
 49  BLOCKS                                             NUMBER
 50  CREATE_BYTES                                       NUMBER
 51  BLOCK_SIZE                                         NUMBER
 52  NAME                                               VARCHAR2(513)
 53  PLUGGED_IN                                         NUMBER
 54  BLOCK1_OFFSET                                      NUMBER
 55  AUX_NAME                                           VARCHAR2(513)
 56  FIRST_NONLOGGED_SCN                                NUMBER
 57 
 58 
 59 SQL> desc V$controlfile;
 60  名称                                      是否为空? 类型
 61  ----------------------------------------- -------- ----------------------
 62 
 63  STATUS                                             VARCHAR2(7)
 64  NAME                                               VARCHAR2(513)
 65  IS_RECOVERY_DEST_FILE                              VARCHAR2(3)
 66  BLOCK_SIZE                                         NUMBER
 67  FILE_SIZE_BLKS                                     NUMBER
 68 
 69 
 70 
 71 SQL> DESC V$PARAMETER;
 72  名称                                      是否为空? 类型
 73  ----------------------------------------- -------- ------------------------
 74 
 75  NUM                                                NUMBER
 76  NAME                                               VARCHAR2(80)
 77  TYPE                                               NUMBER
 78  VALUE                                              VARCHAR2(512)
 79  DISPLAY_VALUE                                      VARCHAR2(512)
 80  ISDEFAULT                                          VARCHAR2(9)
 81  ISSES_MODIFIABLE                                   VARCHAR2(5)
 82  ISSYS_MODIFIABLE                                   VARCHAR2(9)
 83  ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
 84  ISMODIFIED                                         VARCHAR2(10)
 85  ISADJUSTED                                         VARCHAR2(5)
 86  ISDEPRECATED                                       VARCHAR2(5)
 87  DESCRIPTION                                        VARCHAR2(255)
 88  UPDATE_COMMENT                                     VARCHAR2(255)
 89  HASH                                               NUMBER
 90 
 91 SQL> desc V$instance;
 92  名称                                      是否为空? 类型
 93  ----------------------------------------- -------- ----------------------
 94 
 95  INSTANCE_NUMBER                                    NUMBER
 96  INSTANCE_NAME                                      VARCHAR2(16)
 97  HOST_NAME                                          VARCHAR2(64)
 98  VERSION                                            VARCHAR2(17)
 99  STARTUP_TIME                                       DATE
100  STATUS                                             VARCHAR2(12)
101  PARALLEL                                           VARCHAR2(3)
102  THREAD#                                            NUMBER
103  ARCHIVER                                           VARCHAR2(7)
104  LOG_SWITCH_WAIT                                    VARCHAR2(15)
105  LOGINS                                             VARCHAR2(10)
106  SHUTDOWN_PENDING                                   VARCHAR2(3)
107  DATABASE_STATUS                                    VARCHAR2(17)
108  INSTANCE_ROLE                                      VARCHAR2(18)
109  ACTIVE_STATE                                       VARCHAR2(9)
110  BLOCKED                                            VARCHAR2(3)
111 
112 
113 SQL> DESC DBA_OBJECTS;
114  名称                                      是否为空? 类型
115  ----------------------------------------- -------- -----------------------
116 
117  OWNER                                              VARCHAR2(30)
118  OBJECT_NAME                                        VARCHAR2(128)
119  SUBOBJECT_NAME                                     VARCHAR2(30)
120  OBJECT_ID                                          NUMBER
121  DATA_OBJECT_ID                                     NUMBER
122  OBJECT_TYPE                                        VARCHAR2(19)
123  CREATED                                            DATE
124  LAST_DDL_TIME                                      DATE
125  TIMESTAMP                                          VARCHAR2(19)
126  STATUS                                             VARCHAR2(7)
127  TEMPORARY                                          VARCHAR2(1)
128  GENERATED                                          VARCHAR2(1)
129  SECONDARY                                          VARCHAR2(1)
130 
131 
132 SQL> DESC ALL_OBJECTS;
133  名称                                      是否为空? 类型
134  ----------------------------------------- -------- -----------------------
135 
136  OWNER                                     NOT NULL VARCHAR2(30)
137  OBJECT_NAME                               NOT NULL VARCHAR2(30)
138  SUBOBJECT_NAME                                     VARCHAR2(30)
139  OBJECT_ID                                 NOT NULL NUMBER
140  DATA_OBJECT_ID                                     NUMBER
141  OBJECT_TYPE                                        VARCHAR2(19)
142  CREATED                                   NOT NULL DATE
143  LAST_DDL_TIME                             NOT NULL DATE
144  TIMESTAMP                                          VARCHAR2(19)
145  STATUS                                             VARCHAR2(7)
146  TEMPORARY                                          VARCHAR2(1)
147  GENERATED                                          VARCHAR2(1)
148  SECONDARY                                          VARCHAR2(1)
149 
150 SQL> DESC USER_OBJECTS;
151  名称                                      是否为空? 类型
152  ----------------------------------------- -------- ----------------------
153 
154  OBJECT_NAME                                        VARCHAR2(128)
155  SUBOBJECT_NAME                                     VARCHAR2(30)
156  OBJECT_ID                                          NUMBER
157  DATA_OBJECT_ID                                     NUMBER
158  OBJECT_TYPE                                        VARCHAR2(19)
159  CREATED                                            DATE
160  LAST_DDL_TIME                                      DATE
161  TIMESTAMP                                          VARCHAR2(19)
162  STATUS                                             VARCHAR2(7)
163  TEMPORARY                                          VARCHAR2(1)
164  GENERATED                                          VARCHAR2(1)
165  SECONDARY                                          VARCHAR2(1)
--------------------
做一个精神上的素食主义者。