Featured Post

Event Sourcing Video from Michael Ploed

Event Sourcing I want to share a great video I found few days ago that describes very well what Event Sourcing is.

Wednesday, January 10, 2018

ORACLE FUNCTION


BEGIN  
FOR myCounter IN 110000..120000 LOOP 
INSERT INTO "TABLEONE" ("ID", ROW_CREATION, NATIVE_ID)  VALUES (myCounter, sysdate,DBMS_RANDOM.VALUE); 
END LOOP; 
COMMIT; 
END;


DECLARE
    srcAddress varchar2(255);
BEGIN 
    FOR x IN (select "ID" from TABLEONE) LOOP
        FOR myCounter IN 1..5 LOOP 
         INSERT INTO "TABLETWO"  ("ID",TABLEONE,ROW_CREATION) VALUES(myCounter, x."ID", sysdate);
        END LOOP;
    END LOOP;
END;



No comments :

Post a Comment