DPBRANCH Sample

The DPBRANCH table contains branch information.

In this section: DPBRANCH Table Definition DPBRANCH Contents

DPBRANCH Table Definition

  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);

DPBRANCH Contents

  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