Results from Oracle function in cache (10g) ?
From: Alex.Alvarenga <alexssalvarenga_at_gmail.com>
Date: Fri, 23 May 2008 11:03:59 -0700 (PDT)
Message-ID: <ec4741f1-ed42-4e92-a287-af15aeb6a421@w7g2000hsa.googlegroups.com>
drdrd
gygyy
huhuh
jijii
..... and so on....
Date: Fri, 23 May 2008 11:03:59 -0700 (PDT)
Message-ID: <ec4741f1-ed42-4e92-a287-af15aeb6a421@w7g2000hsa.googlegroups.com>
Hy Guys !
I'd like to know if Oracle 10g stores data resulted from a SELECT with Function in Cache ?
Example :
select substr(field_A,3,5) result_str from account;
result_str
drdrd
gygyy
huhuh
jijii
..... and so on....
The result is kept in the cache in this form ?
Tks ...
Alex. Received on Fri May 23 2008 - 13:03:59 CDT