我這個語句錯在哪里了呀
建表語句是這個
CREATE TABLE customers (
customer_id INTEGER CONSTRAINT customers_pk PRIMARY KEY,
first_name VARCHAR2(10) NOT NULL,
last_name VARCHAR2(10) NOT NULL,
dob DATE,
phone VARCHAR2(12)
);
我插入數(shù)據(jù)是這個
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
1,'John','Brown','01-JAN-1965','800-555-1211'
);
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
2,'Cynthia','Green','05-FEB-1968','800-555-1212'
);
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
3,'Steve','White','16-MAR-1971','800-555-1213'
);
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
4,'Gail','Black',NULL,'800-555-1214'
);
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
5,'Doreen','Blue','20-MAY-1970',NULL
);
然后就提示我說無效的月份?咋回事呢,咋修改呢