Sql problem

From: Bosco Ng <boscong_at_leccotech.com>
Date: Mon, 12 May 2003 21:08:52 +0800
Message-ID: <3ebf9c01@shknews01>

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 Received on Mon May 12 2003 - 08:08:52 CDT