2012-11-19 10:26:50 UTC
CREATE TABLE CARS
(REGISTRATION VARCHAR2 (20),
CAR_MAKE VARCHAR2 (20),
WARRANTY VARCHAR2 (8),
MILAGE NUMBER(6)NOT NULL,
CONSTRAINT CARS_PRIMARY_KEY
PRIMARY KEY (REGISTRATION)
);
and this is the data that i'm trying to insert
INSERT INTO CARS
VALUES
('1','KK04ERT','BMW','ONE_YEAR','30500')
and the error it gives me is ORA-00913: too many values
can anyone help me out please?