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 -> Sql problem

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

Original text of this message

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