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!

Null Collection type

996283Oct 31 2013 — edited Oct 31 2013

Hi,

Can anyone ans my doubt which i had regarding null collection and collection variable initialized with empty constructor.

eg.

declare

type num_list is table of number;

lv_col1 num_list;

lv_col2 num_list:=num_list();

begin

null;

end;

my doubt is since both collection variables (lv_col1 and lv_col2) are null, what is the difference between them at server memory level.

Thanks,

Vipin Kumar Rai

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2013
Added on Oct 31 2013
4 comments
598 views