I'm trying to use an oracle Analytic Function to build
Hello,
I'm trying to use an Oracle Analytic Function to build the DAYS_OF_SUCCESS column in a table like below.
Basically, I have a process that runs and when it`s successful the CURRENT_SUCCESS column has a 1 and 0 if there is an error.
What I need is a Analytical Function that will take care of the DAYS_OF_SUCCESS an give me the number of days of success between successful loads.
The result would look like this, starting on may 1. I had 3 days of successful load before en error. then another 6 days before another error.
What I want, Like the example below.