Re: Results from Oracle function in cache (10g) ?

Alex.Alvarenga wrote:
> 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.

Results can be cached in 11g ... not 10g.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org