摘要： http://www.cnblogs.com/lgzslf/archive/2008/11/29/1343685.htmlselect substr(dbms_random.random,2,2) random from (select * from dual order by dbms_random.random)Oracle 取随机数1、从表中随机取记录 select * from (select * from staff order by dbms_random.random) where rownum < 4 表示从STAFF表中随机取3条记录2、产生随机数 SELECT DBM 阅读全文

摘要： -- Create tablecreate table STUDENTS( name VARCHAR2(300), id NUMBER(11), city VARCHAR2(300), no VARCHAR2(300));CREATE OR REPLACE PROCEDURE test IS BEGIN for i in 1 ..100000 loop insert into STUDENTS values('ff',i,'sss','dd'); end loop;commit;END;commend : exec test; 阅读全文

摘要： http://www.worldhello.net/gotgithub/02-join-github/010-account-setup.html 阅读全文