SQLize | PHPize | SQLtest

CREATE TABLE sample_table ( id NUMBER PRIMARY KEY, name VARCHAR2(100), description VARCHAR2(200) ); INSERT INTO sample_table (id, name, description) VALUES (1, 'Item 1', 'Description for item 1'); INSERT INTO sample_table (id, name, description) VALUES (2, 'Item 2', 'Description for item 2'); INSERT INTO sample_table (id, name, description) VALUES (3, 'Item 3', 'Description for item 3'); INSERT INTO sample_table (id, name, description) VALUES (4, 'Item 4', 'Description for item 4'); INSERT INTO sample_table (id, name, description) VALUES (5, 'Item 5', 'Description for item 5'); BEGIN INSERT INTO sample_table (id, name, description) VALUES (21, 'Item 21', 'Description for item 21'); COMMIT; END; / SELECT * FROM sample_table;