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!

difference between "table of varchar" and "varray"????

18338Apr 19 2002
HI.

Hope you can help me. I am not sure if there is and if, what's the difference between:

type VCHAR2ARRAY is table of VARCHAR2(3) index by BINARY_INTEGER;

and

type test is varray(3) of varchar2(1000);

Can you tell me?

In the second case do I have the possibility to do something like

test(1) := 'testkfjskfsdjf';
?


which range is it? From 0-2 or from 1-3?

Thank you very, very much
Henrik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2002
Added on Apr 19 2002
3 comments
447 views