Question: PL/SQL Oracle 12c. Write a procedure which inputs an account ID and returns the customer information for that account. Purpose: To find the customer information

PL/SQL Oracle 12c. Write a procedure which inputs an account ID and returns the customer information for that account.

Purpose: To find the customer information for a given account number

Input parameters: Account ID

Input/Output parameters: None

Output Parameters: Row of customer table that has the account ID

Preconditions: Account ID is valid

Postconditions: Customer Table unchanged. If customer found, customer row returned. If customer not found, return Message "Cust_ID not valid" and customer row is returned as garbage.

- Write a simple driver to call and test the procedure. The driver should print out the fields of the row that is returned.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements...

Assume that your team has been in contract with the headquarters of a company that owns several restaurants in different states in the US. Your team is to provide software that manages these...

Directions: ( CODE IN C ONLY!!!) Complete the following homework assignment using the description given in each section. Do not email code to TAs for help. They cannot help fix compile errors via...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Its about malloc function and I need your help desperately..:( I know there are a lot to do.. I am working on my own but not sure I can finish them. Please help me.. Input files: 1001 1591.63 M 1011...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Please help with this. none of it is making sense to me Lolita's Lovely Locks ACCT 1060_Payroll Accounting Assignment 9_Payroll Project Narrative Introduction In this assignment you are going to...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Purpose: Use command line arguments for input Use malloc() and free()function. Collect input from a text file. Write output to a text file. Creating integer, double and character arrays. To create...

Listed below are some items found in the financial statements of Tony Gruber Co. Indicate in which financial statement(s) the following items would appear. (a) Service revenue. (b) Equipment. (c)...

A production manager knows that 5% of components produced by a particular manufacturing process have some defect. Six of these components, whose characteristics can be assumed to be independent of...

What effect does the issuance of a 2 - for - 1 stock split have on each of the following? ParValue per Share Decrease Decrease Increase Retained Earninges Decrease No effect No effect No effect

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Can you summarise your strategic intent clearly, simply and briefly?

Where using tools like SWOT and PESTLE, are they adding to the thinking, or just there because someone thinks they should be?

Are your conclusions clear and supported by the narrative you have written?