Re: Results from Oracle function in cache (10g) ?
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 24 May 2008 14:29:35 +0200
Message-ID: <e4e8e$48380a2f$524b5c40$3591@cache6.tilbu1.nb.home.nl>
Date: Sat, 24 May 2008 14:29:35 +0200
Message-ID: <e4e8e$48380a2f$524b5c40$3591@cache6.tilbu1.nb.home.nl>
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.
Consider DETERMINSTIC
-- Regards, Frank van BortelReceived on Sat May 24 2008 - 07:29:35 CDT