-
what is the best way to store a table in memory in PL/SQL
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 !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|