Problem 30Write a procedure to delete an invoice, giving the invoicenumber as a parameter. Name the procedure prc_inv_deleteTest the procedure by deleting invoices 9000 and 9001TASK FIGURE P8.16 CH08_SIMPLECO DATABASE TABLESDatabase name: Ch08_SimpleCoTable name: CUSTOMERTable name: INVOICECUST NUM CUST LNAME CUST FNAME CUST BALANCEINV NUM CUST_NUM INV DATE INV AMOUNT1000 SmithJeanne1050.118000100023-Mar-16235.891001 OrtegaJuan840.928001100123-Mar-16312.828002528.10100130-Mar-161000800312-Apr-16194.78800423-Apr-161000619.44

Question
Asked Nov 18, 2019
17 views

HELP IN DATABASE

THIS DID NOT WORK

CREATE OR REPLACE PROCEDURE PRC_INV_DELETE (W_IN IN NUMBER) AS
BEGIN
IF W_IN IS NOT NULL THEN
DELETE FROM INVOICE WHERE INV_NUM = W_IN;
END IF;
END; 

Problem 30
Write a procedure to delete an invoice, giving the invoice
number as a parameter. Name the procedure prc_inv_delete
Test the procedure by deleting invoices 9000 and 9001
TASK
help_outline

Image Transcriptionclose

Problem 30 Write a procedure to delete an invoice, giving the invoice number as a parameter. Name the procedure prc_inv_delete Test the procedure by deleting invoices 9000 and 9001 TASK

fullscreen
FIGURE P8.16 CH08_SIMPLECO DATABASE TABLES
Database name: Ch08_SimpleCo
Table name: CUSTOMER
Table name: INVOICE
CUST NUM CUST LNAME CUST FNAME CUST BALANCE
INV NUM CUST_NUM INV DATE INV AMOUNT
1000 Smith
Jeanne
1050.11
8000
1000
23-Mar-16
235.89
1001 Ortega
Juan
840.92
8001
1001
23-Mar-16
312.82
8002
528.10
1001
30-Mar-16
1000
8003
12-Apr-16
194.78
8004
23-Apr-16
1000
619.44
help_outline

Image Transcriptionclose

FIGURE P8.16 CH08_SIMPLECO DATABASE TABLES Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST FNAME CUST BALANCE INV NUM CUST_NUM INV DATE INV AMOUNT 1000 Smith Jeanne 1050.11 8000 1000 23-Mar-16 235.89 1001 Ortega Juan 840.92 8001 1001 23-Mar-16 312.82 8002 528.10 1001 30-Mar-16 1000 8003 12-Apr-16 194.78 8004 23-Apr-16 1000 619.44

fullscreen
check_circle

Expert Answer

Step 1

The following is the snippet with the modification...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: First, launch NetBeans and close any previous projects that may be open (at the top menu go to File ...

A: Program InstructionsFirst, click on the file and create a new project called “PatternMaker”.Then, cr...

question_answer

Q: PHP  Think of one of your Math homework. How can you use program to reveal the answer? Write a calcu...

A: Program Instructions:The given program implements the Strassen’s method of multiplication between tw...

question_answer

Q: Forest and domain functional level means Windows Operating System version. which one applies? Member...

A: Explanation:A Windows Server 2008 functional level requires that all the Domain Controller (DC)s mus...

question_answer

Q: java write a app that prompts the user for the number of miles and outputs the conversion to kilomet...

A: Program DescriptionA java JavaX application is written which accepts user input in miles and display...

question_answer

Q: This program is written in pseudocodeDesign a program that asks the user to enter 10 golf scores. Th...

A: Few key points related to Arrays:Arrays occupy contiguous memory locations and are of fixed size. Th...

question_answer

Q: Hello! I am new to Java and have nearly finished up a project involving a mortgage table, and everyt...

A: According to the question, students need only in output spacing.To display output in proper spacing ...

question_answer

Q: Write a C++ program: to iteratively compute Fibonacci numbers (named after an Italian mathematician)...

A: A C++ program to generate fibonacci series using recursion is given below,Program://Declare header f...

question_answer

Q: Create a project called Mileage. In it, create a class Car with the following properties. A car has ...

A: Program:package Mileage;public class Car {private double fuelLevel;private double fuelEfficiency;pub...

question_answer

Q: Given the Boolean function F = xy + x’y’ + y’z 1. Implement it with AND, OR, and inverter 2. Impleme...

A: a) Implementing the given Boolean function by using AND, OR and NOT gate:F = xy + x'y' + y'z Logic c...