以下のSQLを実行してテーブル、データを作成する。

--------------------
-- TABLE: Shippers 
--------------------
CREATE TABLE Shippers(
    ShipperID      DECIMAL(10, 0)    NOT NULL,
    CompanyName    VARCHAR(40)    NOT NULL,
    Phone          VARCHAR(24),
    CONSTRAINT PK_Shippers PRIMARY KEY (ShipperID)
)
;

--------------------
-- Sequence: ShipperID
--------------------
CREATE SEQUENCE TS_ShipperID;

--------------------
-- INSERT
--------------------
INSERT INTO Shippers (ShipperID, CompanyName, Phone) VALUES(NEXTVAL for TS_ShipperID, 'Speedy Express', '(503) 555-9831');
INSERT INTO Shippers (ShipperID, CompanyName, Phone) VALUES(NEXTVAL for TS_ShipperID, 'United Package', '(503) 555-3199');
INSERT INTO Shippers (ShipperID, CompanyName, Phone) VALUES(NEXTVAL for TS_ShipperID, 'Federal Shipping', '(503) 555-9930');

