small project involving Oracle SQL query

Calculate the Credit transaction views for each month, per customer. CreditView - In the form 1-0-0-1-1-...etc where 1 is a month with at least one transaction and 0 a month with no transaction CreditVolumeView - In the form 2-1-3-0-1-..etc where each digit is the total volume(number) of transactions for one month CreditAmountView - In the form 128-29-24-89-...etc where each number is the total amount of transactions for one month So each View is a 12-digit delimited sequence, with each digit representing a month from Jan - Dec. So the final output should have the following columns (Example of one row): custid | CreditView | CreditVolumeView | CreditAmountView 11000000 | 1-0-0-1-1-1-0-0-0-1-0-1 | 2-1-3-0-2-3-2-1-4-5-1-6 | 12.67-1000-99-0-23123-67-22-3.3-199-10-0-0