-- 索引组织表IOT
必须指定主键，插入和更新时比较慢，按照索引的顺序插入数据，涉及数据移动。
create table idx_t1(tid number primary key,
                    tname varchar2(20))
                    organization index;
-- 事务级临时表，提交之后就没有数据，占用临时表空间
create global temporary table tmp_t1(tid number ,
                    tname varchar2(20))
                    on commit delete rows;
insert into tmp_t1 values(1,'dasd');
select * from tmp_t1;
commit;
--会话级临时表，会话断开后自动清除
create global temporary table tmp_t2(tid number,tname varchar2(20))
on commit preserve rows;
insert into tmp_t2 values(1,'dasd');
select * from tmp_t2;
----------------------------------------------------
-- 外部表只能读数据，不能修改
先创建一个wwe.txt文档，存入
1,zbn,123,12,aeras
2,xh,324,31,afdasdf
3,zcw,643,45,afbhdfgd
4,ljx,744,63,fghjfgdf
5,lx,563,34,dutfghfh
6,ylj,853,35,fghjfghfgdf
7,yyz,424,36,g6gtf
create directory ext_wwe as 'D:\app';
create table wwe(
sid number,
sname varchar2(20),
sned varchar2(20),
sage varchar2(20),
eee varchar2(20)
)organization external(
type oracle_loader
default directory ext_wwe
access parameters(fields terminated by ',')
location('wwe.txt')
);

ITPub博客

67

最新文章