Displaying results of an Update

I submitted the following update statement in Oracle 8i:

UPDATE wl_aggregate
SET vintage_id=
(SELECT vintage_id FROM vintage_seq
WHERE vintage_seq.orig_year=wl_aggregate.orig_year and vintage_seq.orig_month=wl_aggregate.orig_month and vintage_seq.orig_quarter=wl_aggregate.orig_quarter);

It ran for about 5 hours and then I got the confirmation: 16,900,000 rows updated.

However, when I tried to view the results of the update in wl_aggregate through a SELECT in Oracle ODBC Test, the vintage_id column was null.

Is there something I missed?

--
Posted via CNET Help.com
http://www.help.com/