SQL Oracle DML

DELETE.sql

-- ------------------------------------
-- DELETE
-- ------------------------------------
DELETE FROM dml_test_table WHERE id = 1;

INSERT.sql

-- ------------------------------------
-- INSERT
-- ------------------------------------
INSERT INTO dml_test_table (id, col1) VALUES (1, 'hello');

INTEGRITY.sql

-- ------------------------------------
-- Integritätsprüfung
-- DEFERRED -> Ende Transaktion
-- IMMEDIATE -> Ende DML
-- ------------------------------------
CREATE TABLE transaction_test(
    col1 VARCHAR2(20) NOT NULL INITIALLY DEFERRED,
    col2 VARCHAR2(20) UNIQUE INITIALLY IMMEDIATE
);

TRANSACTIONS.sql

-- ------------------------------------
-- TRANSAKTIONEN
-- ------------------------------------
COMMIT;
ROLLBACK;

UPDATE.sql

-- ------------------------------------
-- UPDATE
-- ------------------------------------
UPDATE dml_test_table SET col1 = 'test' WHERE id = 1;