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!

index by pls integer

1043556Jan 21 2014 — edited Jan 21 2014

Hi all

i am not clear on index by pls integer

in this code by using INDEX BY PLS_INTEGER and with out this i didnt get any error and dif.could you please explain me

TYPE TMP_REC1 IS RECORD
(
   NUM number,
   CODE number,
   YEAR number,
   SEQ_NUM umber
);

  TYPE TMP_REC2 IS TABLE OF TMP_REC1 INDEX BY PLS_INTEGER;
    HOVER_REC TMP_REC2;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2014
Added on Jan 21 2014
6 comments
2,166 views