SQL>desccustomers;
NameTypeNullableDefaultComments
----------------------------------------------
CUSTOMER_IDINTEGER
FIST_NAMEVARCHAR2(10)
LAST_NAMEVARCHAR2(10)
DOBDATEY
PHONEVARCHAR2(12)Y
--向表中添加数据
insertintocustomers(customer_id,first_name,last_name,dob,phone)values(1,'John','Brown',date'1965-1-1','800-555-1211');
默认情况下,oracle的date类型格式为:DD-MM-YYYY,为了在添加和显示数据的时候我们能够更方便的查看数据,将其转化为我们所熟悉的YYYY-MM-DD格式,只要在添加数据时,在此列数据前面加上一个date关键字即可。
--向表中添加空值
insertintocustomers(customer_id,first_name,last_name,dob,phone)
values(3,'Steve','White',null,'800-555-1213');
--或者在表列中不指定此空列:
insertintocustomers(customer_id,first_name,last_name,phone)
values(4,'Steve','White','800-555-1213');
--删除空列
deletefromcustomerswheredobisnull;
--约束分为列级约束和表级约束
--建purchaces表
createtablepurchases(
product_idinteger
--列级约束
constraintpurchases_fk_products
referencesproducts(product_id),
customer_idinteger
constraintpurchases_fk_customers
referencescustomers(customer_id),
quantityintegernotnull,
--表级约束
constraintpurchases_pkprimarykey(product_id,customer_id)
);