i need explanation

Closed

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: Oracle

See more: i need help for my header drop down on blogger, seo i need cleared for the groceries with trevor if on his food card safety reason tomlinson, need 1000 words description for each of our two products pages, include counts of compares and swaps in all trace tables for each row and a total count when done, i need reviews for my business on yelp, i need accountant for self employed, https www upwork com jobs need renders for furniture models_ 013055382a174a5e96, https www upwork com jobs need renders for furniture models 013055382a174a5e96, do i need architect for play cafe, do i need accountant for my small business, do i need accountant for my business in dhanbad, design a banner for each of our 6, create a sliding menu for each page, companies which need prototypes for apparel, gridview row insert net, need media kit, need build website weight loss planner, sbs 2003 need dns, need neobux clone, need link builder, need flash guru, company need freelance writer, need custom world press theme, need entertainment site, client server explanation flash animation

Project ID: #13436805

20 freelancers are bidding on average $21 for this job

truongnguyen86

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!!

$35 USD in 0 days
(75 Reviews)
5.9
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More

$35 USD in 2 days
(6 Reviews)
3.4
bbdsxl

Dear, I am an experienced Oracle DBA and have written such procedures in production environment many times, so I believe I could tell you all of it for you. Please review my profile to know me more, and hope to work More

$20 USD in 1 day
(1 Review)
1.8
ellenutza

Hello, My name is Elena and I am an Oracle developer. I can explain what you need to know about triggers. Best regards, Elena

$15 USD in 0 days
(2 Reviews)
1.4
boio1916

Hello, I work as a DBA for 3 years now. I don't understand if you need to rewrite this code with the insert statement or need an explanation on how triggers work. Anyway you can contact me to discuss . Best Regar More

$10 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
sanket0209

I am Oracle Certified pl sql developer with 2.5 years of experience in IT. The code uses basic concept of trigger and i can explain you very easily.

$10 USD in 1 day
(0 Reviews)
0.0
rajeetbgl

Having 16+ years of professional experience in Application Software Development including 4+ years in Oracle Apps 11i/R12. Working in Oracle Applications 11i/R12 Interfaces and Customization. Experience includes Deve More

$25 USD in 1 day
(0 Reviews)
0.0
no7mind

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

$25 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
$27 USD in 1 day
(0 Reviews)
0.0
neveen2013

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.

$20 USD in 0 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
vw7583098vw

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
shyamg901

Explanation : CREATE OR REPLACE TRIGGER TRG_LINE_TOTAL # creates a Trigger named TRG_LINE_TOTAL BEFORE INSERT ON LINE #Here we specify when the Trigger should Fire #In this case, Trigger TRG_LINE_TOTAL fires B More

$20 USD in 1 day
(0 Reviews)
0.0
kbilalsalim

Over fifteen years of database design, development and administration experience with oracle. Started as a developer to work with forms and reports. In addition to that I also used to take part in the schema manage More

$20 USD in 3 days
(0 Reviews)
0.0
MIchaelPiankov

Hi. As i understand it dosen't work. You need just a bit change of trigger. First add semicolon after multiplication. Second add :new before LINE_TOTAL Third replace '=' to ':=' CREATE OR REPLACE TRIGGER TRG_L More

$15 USD in 1 day
(0 Reviews)
0.0
unicaweb

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.

$20 USD in 1 day
(0 Reviews)
0.0
raheelwaqar3

Hello Sir, Raheel here. I've done too many projects in Databases having great knowledge about it. I assure you that I'll deliver your project on time and you can also visit my profile for surety. I hope you will con More

$25 USD in 1 day
(0 Reviews)
0.0
hariganeshapps

A proposal has not yet been provided

$27 USD in 1 day
(0 Reviews)
0.0