黄松平.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 37 行

1
create table sp_student(sno int not null,sname varchar2(10) not null,age int ,sex char(2));

create view sp_student_view as
select sname,sex ,age from sp_student;
alter table sp_student modify sno default 1;

create or replace trigger sp_stu_tri
instead of insert 
on sp_student_view
for each row
begin
  insert into sp_student(sname,age,sex) values(:new.sname,:new.age,:new.sex);
end;


2
create  sequence sp_sqe
increment by 1
start with 1
maxvalue 999999
minvalue 1
cache 10;

3
declare
v_i int;
begin
  for v_i in 1..10000 loop
  insert into hsp_table values(sp_sqe.nextval,'bush','男',sysdate);
  end loop;
end;

create index name_index on hsp_table(name);

create index fun_index_birth on hsp_table to_char(birthday,'yyyy/mm/dd');