SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fill Down Function

428693Aug 31 2004 — edited Sep 1 2004

I'm trying to build a PL/SQL utility to Fill a column, something similar to the Excel Fill Down function. I've found LAG as a solution but it seems limited to one row and I need many rows.
I tried to use a cursor but ran into problems defining a cursor on variable table and column names.

Any suggestions ?

Thanks in advance,
Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2004

Added on Aug 31 2004

6 comments

941 views