BOOLEAN不是有效的Oracle SQL数据类型。（它是PL/SQL中的有效数据类型。）
您可以使用不同的数据类型，如CHAR(1)或NUMBER(1,0)，并添加检查约束以将其限制为'Y'/'N'或1/0。

CREATE TABLE Plays (
    playId         INT PRIMARY KEY,
    gameId         INT,
    playNumber     INT,
    quarter        INT,
    time           TIMESTAMP,
    yardLine       INT,
    possessionTeam VARCHAR2(10),
    playType       VARCHAR2(10),
    yardGain       INT,
    yardsToGo      INT,
    down           INT,
    distance       INT,
    yardsToEndzone INT,
    scoreDiff      INT,
    epa            REAL,
    isRush         CHAR(1) CHECK (isRush IN ('Y', 'N')),
    isPass         CHAR(1) CHECK (isPass IN ('Y', 'N')),
    isIncomplete   CHAR(1) CHECK (isIncomplete IN ('Y', 'N')),
    isTouchdown    CHAR(1) CHECK (isTouchdown IN ('Y', 'N')),
    passType       VARCHAR2(10),
    passLocation   VARCHAR2(10),
    rushDirection  VARCHAR2(10),
    rushLocation   VARCHAR2(10),
    receiver       VARCHAR2(20),
    defender       VARCHAR2(20)
);

fiddle

在Oracle中，不能使用BOOLEAN数据类型。
有效的create语句如下所示：

CREATE TABLE Plays
(playId INT PRIMARY KEY,
 gameId INT,
 playNumber INT,
 quarter INT,
 time TIMESTAMP,
 yardLine INT,
 possessionTeam VARCHAR2(10),
 playType VARCHAR2(10),
 yardGain INT,
 yardsToGo INT,
 down INT,
 distance INT,
 yardsToEndzone INT,
 scoreDiff INT,
 epa REAL,
 isRush char(1),
 isPass char(1),
 isIncomplete char(1),
 isTouchdown char(1),
 passType VARCHAR2(10),
 passLocation VARCHAR2(10),
 rushDirection VARCHAR2(10),
 rushLocation VARCHAR2(10),
 receiver VARCHAR2(20),
 defender VARCHAR2(20));