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 append varray variable value to varray variable

SravpremJun 11 2014 — edited Jun 11 2014

Hi All,

Can you please help on this, how to appen varray variable to varrary variable

I have an object.. and varray for that object

CREATE OR REPLACE TYPE part_history AS OBJECT ( INVENTORY_ITEM_ID VARCHAR2(20), PART_NUMBER VARCHAR2(100) )

create or replace TYPE PART_HISt_v as VARRAY(2250) OF part_history ;

my_favorites PART_HISt_v;
dad_favorites PART_HISt_v;

lets assume i have inserted 2 rows in my_favorites variable and 2 rows in dad_favorites variable.... now i want to append dad_favorites variable values to my_favorites variable value. how to write this? after appending my_favorites should contain 4 records...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2014

Added on Jun 11 2014

5 comments

1,395 views