oracle ´æ´¢¹ý³Ì±¸Íü

´´½¨sequenceµÄ·½·¨£º
CREATE SEQUENCE SEQ_B_USER_ID INCREMENT BY 1 START WITH 1; 
¸´ÖÆÒ»¸ö±íµÄ½á¹¹£º
create table test as select * from bookmarkcategory where 1=2; 
Ëæ»úÊý£º
 select dbms_random.value(1,20) from dual; 
ÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì £º
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
    INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM        IN     NUMBER,
ED_NUM        IN     NUMBER
)
IS
BEGIN
declare
       i   number;
begin
FOR i IN ST_NUM..ED_NUM LOOP
INSERT INTO tb values(i,i,'3','3','3',100,'0');
END LOOP;
end;
END;
ÔËÐУº
sql>execute INSERTAMOUNTTEST(1,45000)   -- Ò»´Î²åÈë45000Ìõ²âÊÔÊý¾Ý
PROCEDURE p_insert_t 
 (v_x in NUMBER) 
 IS
 temp_id number; 
 BEGIN
 FOR i IN 1..v_x LOOP 
 select SEQ_B_USER_ID.nextval into temp_id from dual; 
 insert into buser (id, username, nickname, status, createdtime) values(temp_id, to_char(temp_id), to_char(temp_id), 0, sysdate); 
 END LOOP; 
 END; 
´Ó´æ´¢¹ý³ÌÖзµ»ØÖµ£º
create or replace procedure spaddflowdate
(
varAppTypeId               in varchar2,
varFlowId                  in varchar2,
DateLength                 in number,
ReturnValue                out number    --·µ»ØÖµ
)
is
begin
insert into td values(varAppTypeId,varFlowId,Date