Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*Lab7*/
- /*Zad2*/
- CREATE MATERIALIZED VIEW my_sprzedaz_2
- BUILD IMMEDIATE
- REFRESH FAST
- NEXT sysdate+(1/24/60)
- AS
- SELECT * FROM sprzedaz@link1;
- SELECT * FROM my_sprzedaz_2;
- /*zdalnie*/
- CREATE MATERIALIZED VIEW LOG
- ON sprzedaz
- WITH PRIMARY KEY, ROWID (cena_jednostkowa);
- INSERT INTO sprzedaz VALUES (5, 1, 2, 30, '6-JAN-2006');
- COMMIT;
- UPDATE sprzedaz
- SET cena_jednostkowa = 130
- WHERE id_sklepu = 5 AND id_produktu = 1 AND liczba_sztuk = 2;
- COMMIT;
- DELETE FROM sprzedaz
- WHERE cena_jednostkowa = 130;
- COMMIT;
- SELECT * FROM MLOG$_sprzedaz;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement