Re: Displaying results of an Update

Did you issue "commit" after the update?

Guang

In article <ss1v5pg6ct6184_at_corp.supernews.com>,   Colleen <cboc70_at_yahoo.com> wrote:
> 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/
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 14 2000 - 14:26:01 CDT