0
Good afternoon, would like to create "Cycles" (Cycle field, increasing sequential numbering), where the beginning of the cycle will always be in the "Cod = 10 (Cod field)" and the End of cycle the "Cod 99 (Cod field)". In the case of the End of Cycle if it is "Cod = 99" (in red) consider a single End. The "Accumulated Time" column must contain the sum of each Cycle.
Thanks for your attention and cooperation.
It was unclear , at least to me , the cycle column already exists ? Would it just be a view in a select ? However search by SEQUENCE CICLE.
– Motta
Good afternoon, Cycle column does not exist. I need to display at SELECT.
– MMPF
http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23sql-1906475.html try a "running total"
– Motta