K
Kizspy.me
Create a trigger named trgUpdateRequiredDate on the required_date column of the orders
table to ensure that required_date is not earlier than order_date. However, if the required_date
is valid, it will take effect, and the data will be updated.
For example, when the following statement is executed, the output will appear as shown in
the following figure:
Zoom
UPDATE Orders
SET required_date="2016-01-01"
WHERE order_id=9
select * from Orders where order_id = 9
order_id
1 9
customer_id order_status order_date required_date shipped_date store_id
60
2016-01-05 2016-01-08 2016-01-08 1
4
Picture 8.1
Question 9:
Create a procedure named prcgetCategory to get the category name of a product based on
product name.
For example, when the following statement is executed, the output will appear as shown in
the following figure:
+ 100%
Close
