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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can this be optimized further?

Re: Can this be optimized further?

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 6 Sep 2001 04:42:14 -0700
Message-ID: <c18ea449.0109060342.963ac8a@posting.google.com>


try
===

create table SP_spr_sp0140767 as
select i.id
,spr.espdate
,spr.promotability
,spr.potential
,spr.evaluator
,spr.evalcomments
,spr.sme
,spr.smeexpertise

from esp_individ_d i
, esp_sprating_d spr

where i.id = spr.id (+)
and nvl(spr.espdate,'x') = (select nvl(max(espdate),'x') from esp_sprating_d r where i.id=r.id ) Received on Thu Sep 06 2001 - 06:42:14 CDT

Original text of this message

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