Re: Sql problem

From: andrewst <member14183_at_dbforums.com>
Date: Mon, 12 May 2003 13:55:37 +0000
Message-ID: <2868586.1052747737@dbforums.com>

Originally posted by Bosco Ng
> I have a sql statement that looks like this
>
> select
> a.c1,
> a.c2,
> b.c3,
> some_pkg.find_last_record(a.c1, b.c3)
> from a,
> b
> where a.id = b.id
> and some_pkg.find_last_record(a.c1, b.c3) is not null
>
>
> the some_pkg.find_last_record takes the 2 parameters to find the
> last record
> that match them.
>
> The problem now is that when this sql fire, it will execute 2
> times the
> some_pkg.find_last_record for 2 times, is there a way to only
> firing it for
> 1 time?
>
>
> Thanks

Do this:

select c1,c2,c3,c4 from
( select

   a.c1,
   a.c2,
   b.c3,

   some_pkg.find_last_record(a.c1, b.c3) c4 from a,

          b
where a.id = b.id
)
where c4 is not null

--
Posted via http://dbforums.com

Received on Mon May 12 2003 - 08:55:37 CDT