oracle数据库创建表代码示例

最新推荐文章于 2024-07-31 09:54:58 发布

-似曾相识燕归来

最新推荐文章于 2024-07-31 09:54:58 发布

阅读量2.4k

点赞数

分类专栏： Oracle 文章标签： 11g oracle 数据库表

本文链接：https://blog.csdn.net/hzh_csdn/article/details/51426751

版权

Oracle 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

创建普通表RJCSTU_BEB1

create table RJCSTU_BEB1(
s_no char(11),
s_fullname nvarchar2(12),
stusex varchar2(6) default '女',
s_enroll date default sysdate,
stu_score number(5,0) default 510,
stumonitor char(11),
studepart nvarchar2(9)
)
tablespace TBS_GEE 
enable row movement 
initrans 29 storage(buffer_pool keep);

创建分区表RJCCOU_DBG2

create table RJCCOU_DBG2(
couno char(12),
c_name varchar2(18),
coukind varchar2(30) default '专业必修',
cmod date default sysdate,
cou_credit number(2,0) default 4,
couprevcou  char(12),
) partition by range(cou_credit)(

 partition P_RJCCOU_DBG2_cou_credit_1 values less than (2) tablespace TBS_512 initrans 3,

partition P_RJCCOU_DBG2_cou_credit_2 values less than (5) tablespace USER72E initrans 23,

partition P_RJCCOU_DBG2_cou_credit_3 values less than (maxvalue) tablespace TBS_512 initrans 14

);

创建索引组织的表RJCCOU_GAA3

create table RJCCOU_GAA3(
cid char(7),
couname varchar2(21),
cou_type nchar(2) default '必修',
coumod date default sysdate,
cou_credit number(1,0) default 4,
couprev char(7),
prof varchar2(27),
primary key (cid)
) 
organization index 
tablespace T2_GGE 
initrans 6 
overflow tablespace T8_GEE initrans 9 ;

创建包含大对象段的表RJCPAR_FBB4

create table RJCPAR_FBB4(
parid char(36),
parname varchar2(27),
p_kind nchar(3) default '条状',
parleave date default sysdate,
p_quantity number(9,0) default 100,
p_subpart char(36),
p_workshop nchar(8),
p_comment clob,
par_pic blob
)
initrans 20 storage(buffer_pool recycle)
tablespace T2_GGE Lob(p_comment) store as lob_p_comment (tablespace T8_GEE)
Lob(par_pic) store as lob_par_pic (tablespace T16_AEF);

创建全局临时表RJCCOU_ADC7

CREATE GLOBAL TEMPORARY TABLE RJCCOU_ADC7
ON COMMIT DELETE ROWS
AS SELECT * FROM RJCCOU_DBG2;

为表RJCCOU_ADC7以及各个字段添加说明

comment on table RJCCOU_ADC7 is '课程信息-临时表';
comment on column RJCCOU_ADC7.couno is '课程号';
comment on column RJCCOU_ADC7.c_name is '课程名称';
comment on column RJCCOU_ADC7.coukind is '课程种类';
comment on column RJCCOU_ADC7.cmod is '修改日期';
comment on column RJCCOU_ADC7.cou_credit is '课程学分';
comment on column RJCCOU_ADC7.couprevcou is '先修课';
comment on column RJCCOU_ADC7.cprof is '所属专业';