PL/SQL function [8.0.5]
From: iks <oopsik_at_spoczta.onet.pl>
Date: Wed, 15 Nov 2000 18:54:09 +0100
Message-ID: <8uuilr$oj3$1_at_orfika.office.polbox.pl>
Date: Wed, 15 Nov 2000 18:54:09 +0100
Message-ID: <8uuilr$oj3$1_at_orfika.office.polbox.pl>
Hi,
I have pl/sql function, so I can use it in sql statements like built-in
funtion.
SQL statement is like following:
select key, function(key) fun_value from table where function(key) > 10
My question is: how many times oracle calls this function
for each record: once or twice ?
I cannot use:
select key, function(key) fun_value from table
where fun_value > 10
I have oracle 8.0.5.
Tia,
x Received on Wed Nov 15 2000 - 18:54:09 CET