create cluster BOOKandAUTHOR (Title VARCHAR2(100));
create table BOOKSHELF
(Title VARCHAR2(100) primary key,
Publisher VARCHAR2(20),
CategoryName VARCHAR2(20),
Rating VARCHAR2(2)
) cluster BOOKandAUTHOR(Title);
create index BOOKandAUTHORndx on cluster BOOKandAUTHOR;
/*
删除重来
drop table BOOKSHELF;
drop table BOOKSHELF_AUTHOR;
drop cluster BOOKandAUTHOR;
插入例子
insert into BOOKSHELF select '1','a','a','a' from dual;
insert into BOOKSHELF select '2','a','a','a' from dual;
insert into BOOKSHELF select '3','a','a','a' from dual;
insert into BOOKSHELF select 'a','a','a','a' from dual;
insert into BOOKSHELF select 'b','a','a','a' from dual;
insert into BOOKSHELF select 'c','a','a','a' from dual;
insert into BOOKSHELF_AUTHOR select '1','a' from dual;
insert into BOOKSHELF_AUTHOR select '2','a' from dual;
insert into BOOKSHELF_AUTHOR select '3','a' from dual;
insert into BOOKSHELF_AUTHOR select 'c','a' from dual;
*/
create table BOOKSHELF_AUTHOR
(
Title VARCHAR2(100),
AuthorName VARCHAR2(50),
constraint TitleFK Foreign key (Title) references BOOKSHELF(Title)
)
cluster BOOKandAUTHOR(Title)
select * from BOOKSHELF_AUTHOR
create table BOOKSHELF
(Title VARCHAR2(100) primary key,
Publisher VARCHAR2(20),
CategoryName VARCHAR2(20),
Rating VARCHAR2(2)
) cluster BOOKandAUTHOR(Title);
create index BOOKandAUTHORndx on cluster BOOKandAUTHOR;
/*
删除重来
drop table BOOKSHELF;
drop table BOOKSHELF_AUTHOR;
drop cluster BOOKandAUTHOR;
插入例子
insert into BOOKSHELF select '1','a','a','a' from dual;
insert into BOOKSHELF select '2','a','a','a' from dual;
insert into BOOKSHELF select '3','a','a','a' from dual;
insert into BOOKSHELF select 'a','a','a','a' from dual;
insert into BOOKSHELF select 'b','a','a','a' from dual;
insert into BOOKSHELF select 'c','a','a','a' from dual;
insert into BOOKSHELF_AUTHOR select '1','a' from dual;
insert into BOOKSHELF_AUTHOR select '2','a' from dual;
insert into BOOKSHELF_AUTHOR select '3','a' from dual;
insert into BOOKSHELF_AUTHOR select 'c','a' from dual;
*/
create table BOOKSHELF_AUTHOR
(
Title VARCHAR2(100),
AuthorName VARCHAR2(50),
constraint TitleFK Foreign key (Title) references BOOKSHELF(Title)
)
cluster BOOKandAUTHOR(Title)
select * from BOOKSHELF_AUTHOR
select * from BOOKSHELF a left join BOOKSHELF_AUTHOR b on a.title=b.title