SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE mytable( id NUMBER GENERATED BY DEFAULT AS IDENTITY, col1 VARCHAR2(255) NOT NULL, col2 VARCHAR2(255) NOT NULL, source_hash VARCHAR2(255), target_hash VARCHAR2(255), PRIMARY KEY(id) ); INSERT INTO mytable (col1, col2) VALUES ('a', 'b'); INSERT INTO mytable (col1, col2) VALUES ('c', 'd'); INSERT INTO mytable (col1, col2) VALUES ('e', 'f'); create or replace procedure measure_insert_perftest_clobs() is startTime number; elapsed number; begin startTime := unix_timestamp(); elapsed := unix_timestamp() - startTime; end;