Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data in a table stored in memory for faster access to them

francy77Jul 4 2018 — edited Jul 15 2018

Hi all,

I want to store in memory data that are in a table; Try to explain better:

the result set of this query:

select field1,

       filed2,

       filed3  

from table t

I should want to store the result in a varray or associative array, in order to have the result set in memory;

and after given a couple (field1,field2) getting the value of field field3;

Which one is the better way to accomplish that?

thanks really much.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2018
Added on Jul 4 2018
34 comments
3,707 views