Skip to Main Content
Forums

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!

What is the starting index of an array?

605079Jan 28 2008 — edited Jan 28 2008
Hi. I know this is simple but i got mixed up with different languages so I am not sure what's the starting index for an array in oracle. For example:

I have an array type var_array and I am declaring my array like this:


arrTemp := var_array('a','b','c','d','e');

Is the starting index of the array above 1 or 0? I mean if I want to get the first element, is it arrTemp(0) or arrTemp(1)? Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2008
Added on Jan 28 2008
3 comments
968 views