Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE DEPARTMENT(DepartmentNo CHAR(4) PRIMARY KEY )
CREATE TABLE STAFF
(StaffID VARCHAR(3),
GivenName VARCHAR(20) NOT NULL,
FamilyName VARCHAR(20) NOT NULL,
DateOfBirth DATE,
Email VARCHAR(50) NOT NULL UNIQUE,
Mobile VARCHAR(10),
State VARCHAR(3),
Salary NUMBER(4,2) NOT NULL,
DepartmentNo CHAR(4),
CONSTRAINT staffpk PRIMARY KEY (StaffID),
CONSTRAINT chkgivenname CHECK (GivenName LIKE '%[^A-Z]%'),
CONSTRAINT chkfamilyname CHECK (FamilyName LIKE '%[^A-Z]%'),
CONSTRAINT chkdate CHECK (DateOfBirth >= '01/MAR/1900'),
CONSTRAINT chkemail CHECK (Email LIKE '%_@__%.__%'),
CONSTRAINT chkmobile CHECK (Mobile LIKE '%[^0-9]%'),
CONSTRAINT chkstate CHECK (State IN ('WA','VIC','QLD','SA','NSW','TAS','NT','ACT')),
CONSTRAINT stafffk FOREIGN KEY (DepartmentNo)
        REFERENCES DEPARTMENT(DepartmentNo)
        ON UPDATE CASCADE);
ORA-00905: missing keyword

CREATE TABLE STAFF
(StaffID VARCHAR(3),
GivenName VARCHAR(20) NOT NULL,
FamilyName VARCHAR(20) NOT NULL,
DateOfBirth DATE,
Email VARCHAR(50) NOT NULL UNIQUE,
Mobile VARCHAR(10),
State VARCHAR(3),
Salary NUMBER(4,2) NOT NULL,
DepartmentNo CHAR(4),
CONSTRAINT staffpk PRIMARY KEY (StaffID),
CONSTRAINT chkgivenname CHECK (GivenName LIKE '%[^A-Z]%'),
CONSTRAINT chkfamilyname CHECK (FamilyName LIKE '%[^A-Z]%'),
CONSTRAINT chkdate CHECK (DateOfBirth >= '01/MAR/1900'),
CONSTRAINT chkemail CHECK (Email LIKE '%_@__%.__%'),
CONSTRAINT chkmobile CHECK (Mobile LIKE '%[^0-9]%'),
CONSTRAINT chkstate CHECK (State IN ('WA','VIC','QLD','SA','NSW','TAS','NT','ACT')),
CONSTRAINT stafffk FOREIGN KEY (DepartmentNo)
        REFERENCES DEPARTMENT(DepartmentNo)
        ON DELETE CASCADE);