Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO STATION VALUES (13, 'Phoenix', 'AZ', 33, 112);
- INSERT INTO STATION VALUES (44, 'Denver', 'CO', 40, 105);
- INSERT INTO STATION VALUES (66, 'Caribou', 'ME', 47, 68);
- SELECT ProductID, Purchasing.Vendor.BusinessEntityID, Name
- FROM Purchasing.ProductVendor JOIN Purchasing.Vendor
- ON (Purchasing.ProductVendor.BusinessEntityID = Purchasing.Vendor.BusinessEntityID)
- WHERE StandardPrice > $10
- AND Name LIKE N'F%'
- GO\
- CREATE OR REPLACE TRIGGER display_salary_changes
- BEFORE DELETE OR INSERT OR UPDATE ON customers
- FOR EACH ROW
- WHEN (NEW.ID > 0)
- DECLARE
- sal_diff NUMBER;
- BEGIN
- sal_diff := :NEW.salary - :OLD.salary;
- dbms_output.put_line('Old salary: ' || :OLD.salary);
- dbms_output.put_line('New salary: ' || :NEW.salary);
- dbms_output.put_line('Salary difference: ' || sal_diff);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement