I have table A with my account balance and i would like to use this data to insert them into my new table B. In this table I would like to see my account balance per day.
Is this possible with Oracle sql? Is there a insert statement or a function which i can use?
I would be very happy if someone can help me.
Table A
Date from Date until Balance
1-1-2018 5-1-2018 125
Table B
Date Balance
1-1-2018 125
2-1-2018 125
3-1-2018 125
4-1-2018 125
5-1-2018 125
Is this possible with Oracle sql? Is there a insert statement or a function which i can use?
I would be very happy if someone can help me.
Table A
Date from Date until Balance
1-1-2018 5-1-2018 125
Table B
Date Balance
1-1-2018 125
2-1-2018 125
3-1-2018 125
4-1-2018 125
5-1-2018 125