Re: Insert data into varray

From: Marcin 'dethar' Jurasz <dethar_at_gmail.com>
Date: Fri, 29 Apr 2005 18:08:13 +0100
Message-ID: <14uyas1web6og.p2sca4ubhspx.dlg@40tude.net>

Fri, 29 Apr 2005 08:50:16 -0700, DA Morgan wrote:

> Post the DDL and repost your DML.

--====================== DDL =================================
CREATE OR REPLACE TYPE t_address AS OBJECT (
 street        varchar2(20),
 city          varchar2(20),

 postal_code varchar2(6)
);
/

CREATE TYPE t_vphonenos AS VARRAY(3) OF VARCHAR2(15);

CREATE OR REPLACE TYPE t_customer AS OBJECT (

 id           number(4),
 name_1       varchar2(20),
 name_2       varchar2(20),
 surname      varchar2(20),
 nip          varchar2(13),
 regon        varchar2(15),
 pesel        varchar2(11),
 address      t_address,

 phone_nos t_vphonenos
);
/

CREATE TABLE tab_customers OF t_customer (  id PRIMARY KEY
)
OBJECT ID PRIMARY KEY
/

--====================== DML =================================

INSERT INTO tab_customers VALUES(t_customer(1, 'Grzegorz', 'Adam',

'Jarzebski', '567nip', '678regon', '568pesel', t_address('Osinska', '23', 
'24', 'Tuwima', '32-424', 'Towowka'), t_vphonenos('(12) 363-36-36',
'+48 565 565 565')));                             ^^^^^^^^(1)^^^^^^
^^^^^(2)^^^^^^^^^

and I want to add third phone number into phone_nos, so I can do:

UPDATE tab_customers SET phone_nos = t_vphonenos('(12) 363-36-36', '+48 565 565 565','+22 222 525') WHERE id = 1;

and it works (I get what i want), but I'd like to add phone number by "INSERT" instead "UPDATE".

-- 
regards

Received on Fri Apr 29 2005 - 12:08:13 CDT