This is kinda what I was looking for, I was thinking about using some
sort of incrementor myself but I didn't know how to implement it. The
only problem is, I don't have access to add or change anything in our
database, which I guess I would need to create the PL/SQL package
described above. That's why I'm trying to get this done in a single
command.
I was thinking of using LAG to keep track of the last used end point,
but as far as I can tell it would need to be recursive. Is there a
way to make LAG a self-referential function, i.e. with a condition that
checks the value in the same column, but the previous row?
Received on Mon Oct 03 2005 - 16:32:12 CDT
