目录(学习笔记)

--创建储户表create table depositor (   actid              INTEGER              not null,   identify          INTEGER              not null,   lastname          VARCHAR2(10)         not null,   firstname         VARCHAR2(10)         not null,   address1           VARCHAR2(200)        not null,   address2           VARCHAR2(200),   address3          VARCHAR2(200),   account            NUMBER(10,2)         not null,   constraint PK_DEPOSITOR primary key (actid));--查询SELECT * FROM depositor;

select identify  from depositor WHERE identify BETWEEN 10000 AND 30000;

CREATE INDEX deptor_index ON depositor(identify) TABLESPACE tbs_test;

--没有复合索引查询SELECT d.identify FROM depositor d WHERE d.identify>5000 AND d.actid>100500;

--创建复合索引CREATE  INDEX dp_complex_index ON depositor(identify,actid) TABLESPACE tbs_test;

--创建反向键索引CREATE INDEX dpt_reverse_index ON depositor(identify) REVERSE TABLESPACE tbs_test;

--查询所有的firsetname并转换为全部小写SELECT LOWER(d.firstname) FROM depositor d;

--创建lower的函数索引CREATE INDEX dpt_lowerfirstname_index ON depositor(LOWER(firstname)) TABLESPACE tbs_test;

--进行统计查询SELECT COUNT(*) FROM depositor d WHERE d.firstname='Luke';

--创建位图索引CREATE BITMAP INDEX dpt_bitmap_index ON depositor(firstname)  TABLESPACE tbs_test;

--删除索引DROP INDEX deptor_index;DROP INDEX dp_complex_index;