oracle数据库代码.docVIP

create database student; --on (name=,filename=) --log on (name=,filename=) create table student_1 ( no int, name varchar(20), id_no int ); alter table student alter column s_no int not null; alter table student add constraint PK_student primary key (s_no); alter table student add constraint uni_name unique (name); alter table student add s_age int check (s_age = 16 and s_age = 60); insert into student (s_no,name,id_no,s_age) values (1001,汉武帝25); insert into student values (1002,隋炀帝16); insert into student values (1003,唐太宗,null,16); select * from student; --创建表 --没有约束条件的