SQL> desc parts
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------
 PART_ID                                   NOT NULL NUMBER(6)
 PART_TYPE                                 NOT NULL CHAR(1)


 (other columns)


 PURCHASE_COST                                      NUMBER(8,2)
 MATERIAL_COST                                      NUMBER(8,2)
 MATERIAL_QTY                                       NUMBER(6)
 LAST_UPDATED                                       TIMESTAMP(6)
 UPDATED_BY                                         VARCHAR2(30)