Oracle建表语句

select * from dba_data_files;

create tablespace Cinema
datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\Cinema.DBF'
size 20m;

create user Cinema
identified by Cinema
default tablespace Cinema;

grant connect,resource to Cinema;
 
create table FilmInfo(
filmId number(8) primary key,
typeId number(8),
filmName varchar2(50),
actor varchar(50),
director varchar(50),
ticketPrice number(8)
);

create table FileType(
typeId number(8) primary key,
typeName varchar2(20)
);

alter table FilmInfo add constraint fk_typeId foreign key(typeId) references FileType(typeId);

 

create sequence infoSeq

create sequence typeSeq

insert into fileType values(typeSeq.Nextval,'动作')

insert into filminfo values(infoSeq.Nextval,1,'蜘蛛侠','彼得','美国大作，演绎蜘蛛侠的故事',9999);

select * from FilmInfo

select * from FileType