SQLize | PHPize | SQLtest

create table TST_SimpleTable (id number not null , sProductName varchar2(50), dControlDate date, nQuantityIn number, nQuantityOut number); --select * from TST_SimpleTable; CREATE SEQUENCE seq_id MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 10; INSERT INTO TST_SimpleTable (id, sProductName, dControlDate, nQuantityIn, nQuantityOut) VALUES (seq_id.nextval, 'REEBOK', to_date('01-05-2016','DD-MM-YYYY'), round(dbms_random.value(10,20)), round(dbms_random.value(5,15))); INSERT INTO TST_SimpleTable (id, sProductName, dControlDate, nQuantityIn, nQuantityOut) VALUES (seq_id.nextval, 'NIKE' , to_date('01-05-2015','DD-MM-YYYY'), round(dbms_random.value(10,20)), round(dbms_random.value(5,15))); INSERT INTO TST_SimpleTable (id, sProductName, dControlDate, nQuantityIn, nQuantityOut) VALUES (seq_id.nextval, 'PUMA', to_date('01-05-2016','DD-MM-YYYY'), round(dbms_random.value(10,20)), round(dbms_random.value(5,15))); INSERT INTO TST_SimpleTable (id, sProductName, dControlDate, nQuantityIn, nQuantityOut) VALUES (seq_id.nextval, 'ADIDAS' , to_date('01-05-2015','DD-MM-YYYY'), round(dbms_random.value(10,20)), round(dbms_random.value(5,15))); select * from TST_SimpleTable; CREATE OR REPLACE FUNCTION generate_random_name_cyrillic RETURN VARCHAR2 IS names VARCHAR2(100) := 'Цепочка,Серьги,Кольцо,Кулон,Колье'; selected_name VARCHAR2(50); BEGIN -- Split the comma-separated list into an array DBMS_RANDOM.initialize(TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'))); selected_name := TRIM(SUBSTR(names, INSTR(names, ',', 1, CEIL(DBMS_RANDOM.VALUE(0, LENGTH(names) - 1))) + 1, INSTR(names, ',', 1, CEIL(DBMS_RANDOM.VALUE(0, LENGTH(names) - 1) + 1)) - INSTR(names, ',', 1, CEIL(DBMS_RANDOM.VALUE(0, LENGTH(names) - 1))) - 1)); RETURN selected_name; END generate_random_name_cyrillic; / CREATE FUNCTION Dates ( ) RETURN DATE AS DateStart DATE; DateEnd DATE; BEGIN DateStart := to_date('01-01-2098','DD-MM-YYYY'); DateEnd := to_date('31-12-2099','DD-MM-YYYY'); WHILE DateStart <= DateEnd BEGIN INSERT INTO TST_SimpleTable (dControlDate) VALUES(DateStart) SET DateStart = DATEADD(DAY, 1, DateStart) END RETURN DateStart END