pl/sql function to populate dimension table
table Customers
ID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(50)
DOB NOT NULL DATE
EMAIL VARCHAR2(50)
ZIPCODE NOT NULL CHAR(5)
Customer_dim
ID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(50)
DOB NOT NULL DATE
EMAIL VARCHAR2(50)
ZIPCODE NOT NULL CHAR(5)
AGE NOT NULL NUMBER
AGEGROUP VARCHAR2(7)
i need a pl/sql funtion to pull the information from the CUSTOMERS table and populate the
CUSTOMER_dim table with an age in numbers and the age group in words.
the age groups are as such :
11-20 = group1
21-30 = group2
31-40= group3
41-50 = group4
51-60=group 5
11 years ago
20
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- plsqlfunction_.zip
Bids(1)
other Questions(10)
- MATH105 exam
- Distribution Stategies
- "Corporate Responsibility" Please respond to the following:
- Case Study Analyses The Gap, Inc (attachment)
- BUSN - Pros and Cons of being a Technological Leader
- Finance with Complete chapter solution you can change values and get solution
- ACCT 221 Final Exam A+ Graded
- Unit5 - Individual Project
- ACC291 final exam answers
- Ashford ECO 203 Week 3 Discussion 1 and 2
