Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE pracownicy SET etat = 'ADIUNKT' WHERE nazwisko = 'MATYSIAK';
- DELETE FROM pracownicy WHERE etat = 'ASYSTENT';
- commit;
- ROLLBACK;
- SELECT * FROM pracownicy;
- UPDATE pracownicy SET placa_pod = placa_pod * 1.1 WHERE etat = 'ADIUNKT';
- ALTER TABLE pracownicy MODIFY placa_pod NUMBER(7,2);
- ROLLBACK;
- UPDATE pracownicy SET placa_pod = placa_pod + 200 WHERE nazwisko = 'MORZY';
- SAVEPOINT podwyzkamorzego;
- UPDATE pracownicy SET placa_dod = placa_dod + 100 WHERE nazwisko = 'BIALY';
- SAVEPOINT podwyzkabialego;
- DELETE FROM pracownicy WHERE nazwisko = 'JEZIERSKI';
- ROLLBACK TO SAVEPOINT podwyzkabialego;
- SELECT sys_context('USERENV', 'SID') FROM dual;
- UPDATE pracownicy SET placa_pod = placa_pod + 100 WHERE nazwisko = 'KONOPKA';
- SELECT * FROM TABLE(sbd.blokady(395));
- ROLLBACK;
- SET TRANSACTION isolation level READ committed;
- UPDATE pracownicy SET placa_pod = placa_pod - 200 WHERE nazwisko = 'KONOPKA';
- SELECT * FROM pracownicy;
- commit;
- INSERT INTO zespoly(id_zesp, nazwa) VALUES (70, 'testTeam');
- UPDATE zespoly SET id_zesp = 80 WHERE id_zesp = 70;
- DELETE FROM zespoly WHERE id_zesp = 80;
- ROLLBACK;
- CREATE INDEX test_fk ON pracownicy(id_zesp);
- DROP INDEX test_fk;
- ///druga konsola
- SELECT sys_context('USERENV', 'SID') FROM dual;
- SELECT * FROM pracownicy;
- UPDATE pracownicy SET placa_dod = placa_dod + 50 WHERE nazwisko = 'KONOPKA';
- ROLLBACK;
- SET TRANSACTION isolation level READ committed;
- SELECT * FROM pracownicy;
- UPDATE pracownicy SET placa_pod = placa_pod +200 WHERE nazwisko = 'KONOPKA';
- commit;
- SELECT * FROM TABLE(sbd.blokady(395));
- ROLLBACK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement