Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

(I\'ve posted this before but the person spammed my question with copy/pasted in

ID: 3665864 • Letter: #

Question

(I've posted this before but the person spammed my question with copy/pasted info from Oracle) Can someone write this query as PL/SQL for Oracle Database?

There's a template below I've included that is the template I have to use.

Please follow up: I will comment if there are any syntax errors or wrong outputs. I will also rate 'thumbs up' if you are correct.

Specific Database Information: http://imgur.com/a/i1HQy (Link to my Imgur album, including DESC/SELECT * of each 5 tables)

Question (please don't alter it in any way):

Explanation / Answer

AddLineItem.sql

InsertOrderitemsTRG.sql

Lab7.sql