oracle添加主鍵的四種方法:

列級，表級建立主鍵

drop table constraint_test;

1.create table constraint_test

( name_id number not null constraint cons_name_id primary key,

old number )

2.create table constraint_test

( name_id number ?primary key,

old number )

drop table constraint_test;

3.create table constraint_test

(

name_id number not null,

old number ?,

constraint cons_name_id primary key ( name_id )

);

drop table constraint_test;

4.create table constraint_test

(

name_id number not null,

old number

);

alter table constraint_test add constraint cons_name_id primary key ( name_id );

外鍵

drop table course ;

drop table students ;

create table students

(code number ?,

name varchar2(10),

country varchar2(30)

);

alter table students add constraint pk_st_cod primary key ( code);

insert into students values(0001,'zhangsan','shanghai');

insert into students values(0002,'lisi','beijing');

insert into students values(0003,'wangwu','guangzhou');

create table course

(id number,

code ?number,

name varchar2(10),

subject varchar2(30)

);

alter table course ?add constraint pk_co_id primary key ( id);

alter table course ?add constraint fk_co_st foreign key ( code) references ?students(code);

alter table students add foreign key pk_co_id on id;

inser into course(id,code,name,subject) values(1,001,'zhangsan','yuwen');

inser into course(id,code,name,subject) values(2,001,'zhangsan','shuxue');

來自 “ ITPUB博客 ” ，鏈接：http://blog.itpub.net/24179204/viewspace-2127542/，如需轉載，請注明出處，否則將追究法律責任。

總結

以上是生活随笔為你收集整理的oracle绑定主键,oracle添加主键的四种方法:的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。