PL/SQL (MOSC)

MOSC Banner

I'm trying to use an oracle Analytic Function to build

edited May 20, 2016 2:23PM in PL/SQL (MOSC) 4 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center