SQLize | PHPize | SQLtest

-- Create the sample table CREATE TABLE sample_table ( id NUMBER PRIMARY KEY, name VARCHAR2(100), description VARCHAR2(200) ); -- Insert multiple records into the sample table 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'); -- Add more records as needed COMMIT; BEGIN -- Insert a new record into the 'sample_table' INSERT INTO sample_table (id, name, description) VALUES (21, 'Item 21', 'Description for item 21'); -- Commit the transaction COMMIT; END; / SELECT * FROM sample_table;