CREATE TABLE DPBRANCH
    (BRANCH_NUMBER    INTEGER      NOT NULL,
     BRANCH_NAME      CHAR(5)      NOT NULL,
     BRANCH_MANAGER   CHAR(5)      NOT NULL,
     BRANCH_CITY      CHAR(5)      NOT NULL);

  SELECT * FROM DPBRANCH;
  BRANCH_NUMBER BRANCH_NAME BRANCH_MANAGER BRANCH_CITY
  ------------- ----------- -------------- -----------
              1 WEST        PIAF           NY
              2 EAST        SMITH          NY
              3 NORTH       AMES           NY
              4 EAST        ALVIN          MIAMI
              5 WEST         FIELD          MIAMI