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!

Two dimensional Array

273079Feb 13 2008 — edited Apr 11 2008
Hi,

I need help with a two dimensional data structure in Oracle 10g PL/SQL, ie VARRAY,REF Cursor, nested table, etc.

I need to temporary (not on the database) store ITEM and CLAUSE, both these columns will store not more than 100 rows and will be of type number.

I need the easiest and best structure for this problem as well as declaration and usage examples if possible.

Please assist.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Feb 13 2008
11 comments
11,269 views