--1
/*COMMIT-ZATWIERDZAMY ZMIANY KTÓRE ZAPROWADZILIŚMY W BAZIE ZA POMOCĄ POLECEŃ DML
ROLLBACK WYCOFUJEMY ZMIANY ZAPROWADZONE ZA POMOCĄ POLECEŃ DML*/
--2
SET AUTOCOMMIT OFF;
--3
INSERT INTO EMP (ID, FIRST_NAME, LAST_NAME)
VALUES(26,'JAROSLAW','RUTKOWSKI');
COMMIT;
--4
INSERT INTO EMP (ID, FIRST_NAME, LAST_NAME,START_DATE,SALARY)
VALUES(27,'KOWAL','KOWALSKI',TO_DATE('9-07-2005','DD-MM-YYYY'),2000);
SELECT ID, FIRST_NAME, LAST_NAME,START_DATE,SALARY
FROM EMP
WHERE ID=27;
ROLLBACK;
SELECT ID, FIRST_NAME, LAST_NAME,START_DATE,SALARY
FROM EMP
WHERE ID=27;
--5
INSERT INTO EMP (ID, FIRST_NAME,
LAST_NAME,START_DATE,SALARY)
VALUES(
27,
'KOWAL','KOWALSKI',
TO_DATE('9-07-2005','DD-MM-YYYY'),2000);
COMMIT;
--6
--A
UPDATE ITEM SET PRICE=PRICE+PRICE*0.15;
--B
SAVEPOINT S1;
--C
SELECT SUM(PRICE)
FROM ITEM;
--D
UPDATE ITEM SET PRICE=PRICE+PRICE*0.10;
--E
SAVEPOINT S2;
--F
SELECT SUM(PRICE)
FROM ITEM;
--G
UPDATE ITEM SET PRICE=PRICE+PRICE*0.60;
--H
SELECT SUM(PRICE)
FROM ITEM;
--I
ROLLBACK TO SAVEPOINT S2;
--J
SELECT SUM(PRICE)
FROM ITEM;
--K
ROLLBACK TO SAVEPOINT S2;
--L
SELECT SUM(PRICE)
FROM ITEM;
--M
COMMIT;
--7
SET AUTOCOMMIT ON;