摘要: 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 阅读全文
posted @ 2010-09-16 15:55 无双的小宝 阅读(713) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2010-09-16 15:03 无双的小宝 阅读(11861) 评论(0) 推荐(0) 编辑