ops it's getting worse, the function is now called 3 times instead of 2....
TIA
On Mon, Jul 18, 2016 at 3:17 PM, Sayan Malakshinov <xt.and.r@xxxxxxxxx>
wrote:
Oops, I'm sorry, I've inserted predicate with rownum in the wrong place.
Try like this:
select x.z.o1,x.z.o2 from (select get_ot z from dual where rownum>0)x;
--
Best regards,
Sayan Malakshinov
http://orasql.org