01 | -- Oefening 1 |
02 |
03 | UPDATE Customers |
04 | SET cust_name = 'Intertoys B.V.' |
05 | WHERE cust_id BETWEEN 1000000008 AND 1000000010; |
06 |
07 | -- Oefening 2 |
08 |
09 | DELETE Customers |
10 | WHERE cust_id = 1000000007; |
11 |
12 | -- Oefening 3 |
13 |
14 | DELETE OrderItems |
15 | WHERE order_num = 20010 |
16 |
17 | DELETE Orders |
18 | WHERE order_num = 20010 |
19 |
20 | DELETE Customers |
21 | WHERE cust_id = 1000000007; |
Download hier het bestand.