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

Home -> Community -> Usenet -> c.d.o.server -> Re: Explain plan...

Re: Explain plan...

From: <plomax_at_oriolecorp.com>
Date: Wed, 23 Sep 1998 12:44:56 +0100
Message-ID: <3608DF38.8786C844@oriolecorp.com>


If you look closely at your trace you have forgotten a constraint (contrarily to what you think) or the big hidden trigger? The best approach would be to rewrite the view. Regards
Peter

Peter Rak wrote:

> Hi.
>
> I have two SQL statements:
> 1.
> select 1,gco_code,gan_code,sum(remain_amt)
> from vad_otvp_pol_view
> where gan_code='31101' and gco_code='076'
> and gan_gcn_code='ZOS'
> group by gco_code,gan_code;
>
> 2.
> insert into ad_check_saldo (code,gco_code,gan_code,remain_amt)
> select 1,gco_code,gan_code,sum(remain_amt)
> from vad_otvp_pol_view
> where gan_code='31101' and gco_code='076'
> and gan_gcn_code='ZOS'
> group by gco_code,gan_code;
> .....
Received on Wed Sep 23 1998 - 06:44:56 CDT

Original text of this message

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