CODEWITHSUNDEEP
sqloracle-databaseoracle11gvarray
lukas irides
lukas irides

Reputation: 41

Adding elements in a Varray

I'm working on Oracle. If I have table in which one of the attributes is a Varray, like :

create type list_surname as Varray(20) of varchar2(15)
/

create table employes(name varchar2(15),
                      ls_pnm list_surname,
                      adrprivate Tadresse,
                      adrprof REF Tadresse);

Is it possible to add or modify elements containing in an existing ls_pnm ?

Upvotes: 1

Views: 183

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49062

Yes, you can.

UPDATE employees
  SET ls_pnm = list_surname('<list of values>')
 WHERE name ='<conditions>';

Upvotes: 1

Related Questions