Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert data into varray
Hi! Into my database (its part below), i'm trying to insert values.
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),
CREATE TABLE tab_customers OF t_customer (
id PRIMARY KEY
)
OBJECT ID PRIMARY KEY
/
this works fine:
INSERT INTO tab_customers VALUES(t_customer (1, 'Grzegorz', 'Adam', 'Jarzebski', '567nip', '678regon', '568pesel', t_adress('Osinska', '23', '24', 'Tuwima', '32-424', 'Towowka'), t_vphonenos('+48 565 565 565')));
but now i'd like to insert ("add") some data into t_vphonenos (i've inserted one row already ;)). i've tried something like this, but it didn't work:
INSERT INTO tab_customers (phone_nos) VALUES (
t_vphonenos ( ('123123123'), ('345345345') ) );What i'm doing wrong? I've tried also:
INSERT INTO TABLE (SELECT phone_nos FROM tab_customers WHERE id = 1) VALUES (t_vphonenos('123123','1231233'));
Still doesn't work. Someone would help me?
Thanks Received on Thu Apr 28 2005 - 15:37:58 CDT