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!

PL/SQL Table without index by clause

Dev_SQLNov 22 2018 — edited Jan 1 2019

Hi All,

What is the difference between the below 2 statements, especially one without INDEX BY keyword? I'm not trying to use Nested table in this context either. Thank you.

TYPE t_rowid_tbl IS TABLE OF VARCHAR2(10);

TYPE t_rowid_tbl IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;

Comments
Post Details
Added on Nov 22 2018
7 comments
1,046 views