Updating a column based on a 'Windows Function' formula

Hi All,

I want to make the following update:

update TIME_TABLE a
set a.end_date_time = lead(a.start_date_time) over (order by a.start_date_time)

what this does is it takes the next records start time and uses it as an end time.
If i use this in a select statement the results are perfect, but I cant update records using this function.

How can I update the end_date_time column?

Thanks in advance :) Received on Wed Nov 15 2006 - 03:20:59 CST