练习-Oracle管理表

内容
1．建立表；
2．建立约束，设置约束状态。

步骤

==================================
答案

一.管理表

-- Create tablecreate table customers(  cust_code char(3) not null,  name      nvarchar2(10) not null,  zipcode   char(6));-- Create tablecreate 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;

1. 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;

待续