densifying time series data
In https://livesql.oracle.com/apex/livesql/s/dw1gfr8vtb0hefd80aflipe9c I put together some time series data a query to densify the data.
In a table ta_time_series I have two columns: A_ID NUMBER and A_STATUS CHAR(1). Over the sequence of ascending A_IDs (could also be filled via a Sequence) a status A_STATUS can change or remain the same as it was for the previous A_ID. This is my sample data:
| A_ID | A_STATUS |
|---|---|
1 | A |
| 2 | A |
| 3 | B |
| 4 | C |
| 5 | C |
| 6 | B |
| 7 | B |
| 8 | A |
| 9 | A |
The goal is to densify this times series data into this form:
Tagged:
1