内容
1.建立表;
2.建立约束,设置约束状态。
步骤
==================================
答案
一.管理表
-- Create table
create table customers
(
cust_code char(3) not null,
name nvarchar2(10) not null,
zipcode char(6)
)
;
-- Create table
create table orders
(
ord_id number(3) not null,
ord_date date,
ord_code char(3),
date_of_delay date
)
;
二.约束
1. customers插入数据
insert into scott.customers values('A04', '张林', '610021');
insert into scott.customers values('A05', '刘晨', '610071');
insert into scott.customers values('B01', '曾伟', '400013');
insert into scott.customers values('B02', '王一鸣', '400700');
commit;
- orders插入数据
insert into scott.orders values('101', to_date('2008-02-03','yyyy-mm-dd'), 'A01', '');
insert into scott.orders values('102', to_date('2007-10-07','yyyy-mm-dd'), 'A04', to_date('2007-12-07','yyyy-mm-dd'));
insert into scott.orders values('103', to_date('2007-02-12','yyyy-mm-dd'), 'A05', '');
insert into scott.orders values('104', to_date('2009-01-10','yyyy-mm-dd'), 'A04', '');
commit;
待续