Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. Retrieve a list of customer names and address information for those who have terminated accounts using SQL commands (I am using APEX). Customer Account
. Retrieve a list of customer names and address information for those who have terminated accounts using SQL commands (I am using APEX).
Customer Account Person serves as a bridge table, between the person table and customer table.
Table: PERSON ? Column Data Type Length Precision Scale Nullable NUMBER PERSON_ID PERSON GIVEN_NAME PERSON MIDDLE_NAME PERSON FAMILY_NAME PERSON ADDRESS 1 0 No 25 - No -Yes - No - Yes VARCHAR2 VARCHAR2 25 VARCHAR2 25 VARCHAR2 100 Table: CUSTOMER ACCOUNT_PERSON Column Data Type Length Precision Scale Nullable CUSTOMER_ACCOUNTID NUMBER 0 No PERSON ID NUMBER 0 No Table: CUSTOMER ACCOUNT Column Data Type Length Precision Scale Nullable CUSTOMER ACCOUNT ID CUSTOMER HOLD_INDIC DATE ENROLLED DATE TERMINATED NUMBER 0 No - No - No Yes CHAR DATE 7 DATE 7Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started