CREATE TABLE Vitals
(
    Record_No   int NOT NULL PRIMARY KEY,
    Patient_ID  int, 
    Date_Taken  DATE NOT NULL,
    Time_Taken  time(7) NOT NULL,
    Systolic    int, 
    CHECK       (Systolic > Diastolic),
    Diastolic   int,
    Heart_Rate  int CHECK (Heart_Rate > 30),
    CONSTRAINT fk_Patient_ID FOREIGN KEY (Patient_ID) REFERENCES Patients(Patient_ID)
);

但是，我有个错误

Time_Taken time(7) NOT NULL,
               *
ERROR at line 6:
ORA-00907: missing right parenthesis

当我使用 timestamp default systimestamp 它起作用了。我只需要时间 Time_Taken 列。在此处输入图像描述