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
20 freelancers are bidding on average $21 for this job
Hello there, i'm expert on database technology, let me help you with this. I can explain for you in 1 hour. Waiting for your response if interested. Thank you!!
There is nothing tricky in the code U posted. Why didn't U sent it to some of many web sites that will give U help for free? But if U like it better to pay, I am here to help. Best regards
Hello, this is an easy code for me i can explain it in less than an hour in one session team viewer. Please, give me a chance and hire me. It will be good for me to start working with.
Hi, I am an Oracle and PL / SQL expert with more than 10 years of experience. I can create the trigger and test in your environment. If you have any questions, please let me know. Thank you.