Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert data into varray

Re: Insert data into varray

From: Marcin 'dethar' Jurasz <nick_at_gmail.com>
Date: Thu, 28 Apr 2005 23:18:44 +0100
Message-ID: <1vtzkanm5zgkv$.3kidro9co8dd$.dlg@40tude.net>

I've also tried something like this. Now Oracle says "Error at line 1:
ORA-00913: Too many values"

INSERT INTO TABLE (SELECT t.phone_nos FROM tab_customers t WHERE t.id = 1) VALUES ('12ABC','23CDE','34EFG');

:(.

-- 
regards
Received on Thu Apr 28 2005 - 17:18:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US