Showing posts with label Structure of Views. Show all posts
Showing posts with label Structure of Views. Show all posts

Monday, 23 September 2013

Structure of System tables views

Name                                                              Null?              Type
 -----------------------------------------                         --------              ----------------------------
 OWNER                                                      NOT NULL      VARCHAR2(30)
 VIEW_NAME                                            NOT NULL      VARCHAR2(30)
 TEXT_LENGTH                                                                  NUMBER
 TEXT                                                                                     LONG
 TYPE_TEXT_LENGTH                                                      NUMBER
 TYPE_TEXT                                                                        VARCHAR2(4000)
 OID_TEXT_LENGTH                                                         NUMBER
 OID_TEXT                                                                           VARCHAR2(4000)
 VIEW_TYPE_OWNER                                                        VARCHAR2(30)
 VIEW_TYPE                                                                        VARCHAR2(30)
 SUPERVIEW_NAME                                                          VARCHAR2(30)