Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions