|
SQL> CREATE TABLE game_player
2 (player_id NUMBER,
3 game_id NUMBER,
4 group_number NUMBER,
5 marked VARCHAR2(1) DEFAULT 'N',
6 pcmac VARCHAR2(1) DEFAULT 'N',
7 score NUMBER,
8 CONSTRAINT game_player_pk
9 PRIMARY KEY (player_id, game_id, group_number));
Table created.
SQL>
SQL>
SQL> -- changing the defaults
SQL> CREATE OR REPLACE TRIGGER old_new_delete
2 BEFORE delete ON game_player
3 REFERENCING OLD AS old_values NEW AS new_values
4 FOR EACH ROW
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE('Old marked = ' || :old_values.marked);
7 DBMS_OUTPUT.PUT_LINE('New marked = ' || :new_values.marked);
8 END;
9 /
Trigger created.
SQL>
SQL>
SQL>
SQL> drop table game_player;
Table dropped.
|