Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    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