Hi,

CREATE TABLE TBL_DESCRIPTIONS (
DESCR_ID number,
DESCR_TEXT varchar2(200)
);

What is the best way to store it in the memory ?? in what kind of structure ?
Here are some options...

1. make a query everytime when i need to have a value
2. store in variable with index (index is descr_id)
TYPE string_tab_tp IS TABLE OF VARCHAR(200) INDEX BY BINARY_INTEGER;
3. something else ??? do you have any idea ?

Thanks a lot !