摘要:
oracle 9i/10gR2所有版本下载地址(请用迅雷等下载工具下载):---------------------------------------------------------------------------------------------------Oracle 9iOracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XPhttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.ziphtt 阅读全文
摘要:
drop table test;select count(*) from test;--创建测试表create table test(id number(9),nick varchar2(30));--插入测试数据begin for i in 1..100000 loop insert into test(id) values(i); end loop; commit;end;select * from test;--更新nick字段,使数据发生严重倾斜update test set nick='abc' where rownum<99999;--创建索引create i 阅读全文