Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Displaying results of an Update

Re: Displaying results of an Update

From: <gmei_at_my-deja.com>
Date: Thu, 14 Sep 2000 19:26:01 GMT
Message-ID: <8pr8ne$gbn$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US