Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Database Objects > Using DESCRIBE to Get Information on Object Type...

Using DESCRIBE to Get Information on Object Types

You can use the DESCRIBE command to get information on object types. The following examples describe address_typ and person_typ:

DESCRIBE address_typ
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------
 STREET                                              VARCHAR2(15)
 CITY                                                VARCHAR2(15)
 STATE                                              CHAR(2)
 ZIP                                                 VARCHAR2(5)

DESCRIBE person_typ
 Name                                      Null?     Type
 ----------------------------------------- -------- ------------
 ID                                                 NUMBER
 FIRST_NAME                                          VARCHAR2(10)
 LAST_NAME                                           VARCHAR2(10)
 DOB                                                 DATE
 PHONE                                               VARCHAR2(12)
 ADDRESS                                             ADDRESS_TYP


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial