我这个语句错在哪里了呀建表语句是这个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));我插入数据是这
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 17:40:40
![我这个语句错在哪里了呀建表语句是这个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));我插入数据是这](/uploads/image/z/10651332-12-2.jpg?t=%E6%88%91%E8%BF%99%E4%B8%AA%E8%AF%AD%E5%8F%A5%E9%94%99%E5%9C%A8%E5%93%AA%E9%87%8C%E4%BA%86%E5%91%80%E5%BB%BA%E8%A1%A8%E8%AF%AD%E5%8F%A5%E6%98%AF%E8%BF%99%E4%B8%AACREATE+TABLE+customers+%28customer_id+INTEGER+CONSTRAINT+customers_pk+PRIMARY+KEY%2Cfirst_name+VARCHAR2%2810%29+NOT+NULL%2Clast_name+VARCHAR2%2810%29+NOT+NULL%2Cdob+DATE%2Cphone+VARCHAR2%2812%29%29%3B%E6%88%91%E6%8F%92%E5%85%A5%E6%95%B0%E6%8D%AE%E6%98%AF%E8%BF%99)
我这个语句错在哪里了呀建表语句是这个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));我插入数据是这
我这个语句错在哪里了呀
建表语句是这个
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)
);
我插入数据是这个
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
);
然后就提示我说无效的月份?咋回事呢,咋修改呢
我这个语句错在哪里了呀建表语句是这个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));我插入数据是这
Date字段插入时一般用函数,很少直接写.
相对于SQLServer来说,用getdate()函数,可以获取当前日期和时间.你用的是Oracle,可能函数名称有所不同,你自己查查.
例如:
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
5,'Doreen','Blue',getdate(),NULL
);
如果你非要直接写,那么,
INSERT INTO customers (
customer_id,first_name,last_name,dob,phone
) VALUES (
5,'Doreen','Blue',1970-5-20,NULL
);