alter table userinfo_c3
add constraint ck_salary_new
check(salary):
add constraint ck_salary_new
check(salary):
2015-11-25
create table userinfo_c1
(id varchar2(10) primary key,
username varchar2(20) unique,
salary number(5,0) ,
constraint c_salary_new check(salary>0));
(id varchar2(10) primary key,
username varchar2(20) unique,
salary number(5,0) ,
constraint c_salary_new check(salary>0));
2015-11-25
alter table userinfo_u2
add constraint un_username_new
unique (username);
add constraint un_username_new
unique (username);
2015-11-25
create table userinfo_u1
(id varchar2(10) primary key,
username varchar2(20),
constraint un_username uinque(username));
(id varchar2(10) primary key,
username varchar2(20),
constraint un_username uinque(username));
2015-11-25
create table userinfo_u
(id varchar2(20)primary key,
username varchar2(20) unique,
userpwd varchar2(20));
(id varchar2(20)primary key,
username varchar2(20) unique,
userpwd varchar2(20));
2015-11-25
alter table userinfo_f4
add constraint fk_typeid_alter foreign key(typeid_new)
references typeinfo(typeid);
add constraint fk_typeid_alter foreign key(typeid_new)
references typeinfo(typeid);
2015-11-24
短时间内向学oracle基础看这套视频还不错,我本身是学Java的为了应付面试学一星期oracle基础。。。太深的学了也没用,这视频的程度刚好
2015-11-12