摘要:
1、从表中随机取记录 SELECT * FROM ( SELECT * FROM SDXJ.TEST_01 ORDER BY DBMS_RANDOM.random) WHERE ROWNUM < 5; 表示从SDXJ.TEST_01表中随机取4条记录 2、产生随机数 产生一个任意大小的随机数: SE 阅读全文
摘要:
BEGIN FOR i IN 1 .. {count_insert} LOOP INSERT INTO IKASTRIGGER.IKAS10B (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COLUMN6, COLUMN7, COLUMN8, COLUM 阅读全文
摘要:
DROP PROCEDURE IF EXISTS create_user_tel; create procedure create_user_tel(n int) begin declare id int; set id=1; while id <=n do INSERT INTO alam VAL 阅读全文