(CREATE TABLE Order_T ( OrderID NUMBER(5,0) NOT NULL, OrderDate DATE DEFAULT SYSDATE,CustomerID NUMBER(3,0), CONSTRAINT Order_PK PRIMARY KEY (OrderID)); (Default DATE format: DD-MON-YY HH:MI:SS AM/PM(DROP TABLE Order_T; DROP TABLE Customer-T CASCADE CONSTRAINTS;(INSERT INTO Order_T VALUES (12001,…