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!

How to initialize a PL/SQL table?

PaulDddddNov 14 2017 — edited Nov 15 2017

I have a table like this:

TYPE t_sub_totals  IS TABLE OF NUMBER INDEX BY VARCHAR2(100);
v_sub_totals  t_sub_totals;

Now I want to initialize my table with these 3 values

For Index value '0-25' NUMBER is 0

For Index value '26-49' NUMBER is 0

For Index value '50-100' NUMBER is 0

How to dot this pls?
This post has been answered by mathguy on Nov 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2017
Added on Nov 14 2017
5 comments
881 views