16. create or replace procedure sp_result0517 is bhid number:=0.2; cursor custcur is select emp_no,salary from employee where salary <1000 ; tmpb aaaa.salary%type; tmpe aaaa.emp_no%type; begin open custcur; fetch custcur into tmpb,tmpe; loop exit when not custcur%FOUND; update employee set salary =( salary + salary*bhid) where emp_no= tmpe; fetch custcur into tmpb,tmpe; end loop; close custcur; commit; end sp_result0517;
create or replace procedure sp_result0517 is
bhid number:=0.2;
cursor custcur is select emp_no,salary from employee where salary <1000 ;
tmpb aaaa.salary%type;
tmpe aaaa.emp_no%type;
begin
open custcur;
fetch custcur into tmpb,tmpe;
loop
exit when not custcur%FOUND;
update employee set salary =( salary + salary*bhid) where emp_no= tmpe;
fetch custcur into tmpb,tmpe;
end loop;
close custcur;
commit;
end sp_result0517;
B*Tree索引: (索引组织表)
B*Tree聚族索引: (反向码索引)
将序索引
位图索引:一个索引条目使用一个位图同时指向许多行
基于函数的索引
应用程序域索引
interMedia文本索引
。
在 init.ora文件中通过SGA_MAX_SIZE来设置其大小