i need explanation
This project is ending today and has an average bid price of $21 USD.Get free quotes for a project like this
Project Budget$10 - $30 USD
1. Create a trigger named trg_line_total to write the LINE_TOTAL value into the LINE table every time you add a new LINE row. (The LINE_TOTAL value is the product of the LINE_UNITS and the LINE_PRICE values).
CREATE OR REPLACE TRIGGER TRG_LINE_TOTAL
BEFORE INSERT ON LINE
FOR EACH ROW
LINE_TOTAL = :NEW.LINE_UNITS *:NEW.LINE_PRICE
DBMS_OUTPUT.PUT_LINE (‘The Line Total Value is: ’||LINE_TOTAL);
WHEN OTHERS THEN
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online