Open

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
Total Bids
20
Project Description

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

BEGIN

LINE_TOTAL = :NEW.LINE_UNITS *:NEW.LINE_PRICE

DBMS_OUTPUT.PUT_LINE (‘The Line Total Value is: ’||LINE_TOTAL);

EXCEPTION

WHEN OTHERS THEN

DBMS_OUTPUT.PUT_LINE (SQLERRM);

END;

/

Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online