Question

Using the code below in Oracle SQL Live I keep getting an error message for the last 4 INSERTS. The error message is: ORA-00932: inconsistent datatypes: expected DATE got NUMBER. How do I correct that error?

CREATE TABLE BASE (
BASENUM CHARACTER(3) NOT NULL,
BASECITY varchar(20),
BASESTATE CHARACTER(2),
BASEPHON varchar(10),
BASEMGR varchar(10),
PRIMARY KEY (BASENUM)
);

CREATE TABLE TYPE (
TYPENUM CHARACTER(1) NOT NULL,
TYPEDESC varchar(30),
PRIMARY KEY (TYPENUM)
);

CREATE TABLE TRUCK (
TNUM CHARACTER(4) NOT NULL,
BASENUM CHARACTER(3),
TYPENUM CHARACTER(1),
TMILES DECIMAL(7,1) NOT NULL,
TBOUGHT DATE,
TSERIAL varchar(20),
FOREIGN KEY (BASENUM) REFERENCES BASE(BASENUM),
FOREIGN KEY (TYPENUM) REFERENCES TYPE(TYPENUM),
PRIMARY KEY (TNUM)
);
INSERT INTO BASE VALUES('501','Dallas','TX','893-9870','J. Jones');
INSERT INTO BASE VALUES('502','New York','NY','234-7689','K. Lee');

SELECT * FROM BASE;

INSERT INTO TYPE VALUES('1','single box,double axle');
INSERT INTO TYPE VALUES('2','tandem trailer,single axle');

SELECT * FROM TYPE;

INSERT INTO TRUCK VALUES('1001','501','1',5900.2,11/08/90,'aa-125');
INSERT INTO TRUCK VALUES('1002','502','2',64523.9,11/08/90,'ac-213');
INSERT INTO TRUCK VALUES('1003','501','2',32216.0,09/29/91,'ac-215');
INSERT INTO TRUCK VALUES('1004','','2',3256.9,1/14/92,'ac-315');

Answer 1

Use to date function in the insert command like this:
FOR EXAMPLE:
 TO_DATE('12/01/2016', 'MM/DD/YYYY')

 INSERT INTO TRUCK VALUES('1001','501','1',5900.2,TO_DATE('11/08/90','MM/DD/YYYY'),'aa-125');

OR TRY INSERTING WITH QUOTATION MARKS

INSERT INTO TRUCK VALUES('1001','501','1',5900.2,'11/08/90','aa-125');

Please rate it if the above solution helps you in any way or if you have any concerns comment it, I will help you through again.