Closed c-bik closed 5 years ago
The PL/SQL you can use to generate and fill Oracle table in Oracle XE (so in K2 setup).
erlociNif
CREATE TABLE erlociNif ( int integer, flt float, vchr30 varchar2(30), num1m10 number(1,-10), dat date default sysdate, num number, vchr100 varchar2(100), vchr200 varchar2(200), vchr300 varchar2(300), vchr1000 varchar2(1000) )
Change 10 in FOR Lcntr IN 1..10 to the desired number of rows
FOR Lcntr IN 1..10
BEGIN FOR Lcntr IN 1..10 LOOP INSERT INTO erlociNif ( int, flt, vchr30, num1m10, num, vchr100, vchr200, vchr300, vchr1000 ) VALUES ( Lcntr, Lcntr / 2, dbms_random.string('p',30), Lcntr / 3, dbms_random.value(low => -1000, high => 1000), dbms_random.string('p', 100), dbms_random.string('p', 200), dbms_random.string('p', 300), dbms_random.string('p', 1000) ); END LOOP; END;
All of this is quite DDErl + Erloci friendly
Implement with erlang ct
Outdated, not relevant any longer. Latest work continues in common-tests branch
The PL/SQL you can use to generate and fill Oracle table in Oracle XE (so in K2 setup).
Create a
erlociNif
tablePolulate
erlociNif
with random dataChange 10 in
FOR Lcntr IN 1..10
to the desired number of rowsAll of this is quite DDErl + Erloci friendly
Implement with erlang ct