Script below to create an updateable

Assignment Help PL-SQL Programming

Reference no: EM13166912

Use the script below to create an updateable view named balance_due_view. Then, create and test an INSTEAD OF trigger named invoices_instead_of_insert that lets the user update the columns in the view by directly updating the Invoices table. Within this trigger, you can call the stored procedure named insert_invoice that's created by the script for figure 15-5

CREATE OR REPLACE VIEW balance_due_view AS

SELECT vendor_name, invoice_number,

invoice_total, payment_total, credit_total,

invoice_total - payment_total - credit_total AS balance_due

FROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_id

WHERE invoice_total - payment_total - credit_total > 0;

Reference no: EM13166912

Questions Cloud

Write a compete pl/sql program to display the staffno : Write a compete PL/SQL program to display the StaffNo,

Commands that you would use to create a 7x7 matrix : Show the unix/linux commands that you would use to create a 7x7 matrix of alternating entries of 1's and 0's. It should look like this

Project that uses interactions to develop the system : on a project that uses interactions to develop the system, in which interation does systems design begin? explain why

What are the formulas for these worst case time complexities : What are the formulas for these Worst Case Time Complexities?

Script below to create an updateable : Use the script below to create an updateable view named balance_due_view. Then, create and test an INSTEAD OF trigger named invoices_instead_of_insert that lets the user update the columns in the view by directly updating the Invoices table.

Asks a user to enter the radius of a circle : Write a program that asks a user to enter the radius of a circle, and calcualtes the area and the circumference. The program should be written using the following methods.

Phil maintains a blog online : Phil maintains a blog online. What do you do to check that his blog is not revealing sensitive company information? Is he allowed to maintain his blog during work hours

Fluid mechanics : Consider a two-dimensional velocity ?eld V~ = aˆi + by2ˆj, where a = 1 m/s and b = 2 m?1s-1

Use numbers 0 through 23 to represent hours : Write a C function seconds_since_jan1() that takes the time as six integer arguments (year, month, day, hour,minute, and second) and returns the number of seconds since the beginning of the year. Use numbers 1 through 12 to represent months. Use numb..

User Account

All Pages